What is the best performance for this configuration:
Files:
Data
Log
Indexes
tempdb
Disk:
A - RAID 10
B - RAID 10 (or should this be RAID 1?)
Whats best?:
A - Data and Indexes
B - tempdb and Log
? Thanks.
check these links
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx
http://sql-server-performance.com/Community/forums/t/2337.aspx
Madhu
