I am running SQL Server STD 2005 on a Win 2008 STD R2.
For SQL data - separate storage - RAID 5 - where the RAID policy is set to Read Ahead.
When formatting the drive - what - Allocation Size Units is best recommended to get max performance for SQL. Some sites say 4K while some say 64K - so how to pick what and when?
I have an an accounting system and a SharePoint database using this SQL server. All databases files combined is about >50GB