I was wondering if we put the SQL Server Database Log file and tempdb
on RAID 1, should be format it with 64K cluster for better performance?
Currently the database and log file are on RAID5 which I think is the worse for database log if you are doing a lot of inserts as it double writes.
This is for SQL Server 2005
Best Answer
RAID 1 will generally give better read performance but worse write performance, so I would not use it for heavily written logs and TempDB. Ideally, you should go with RAID 10 for SQL Server when possible. See: RAID Levels and SQL Server.
As for your cluster size question, see Disk Partition Alignment Best Practices for SQL Server for an excellent discussion of all the considerations that should be taken into account. The article says it's for SQL 2008 but it is equally relevant for 2005. Here's the most important take away from the article: