We are a large international company and use multiple production Navision SQL instances (NAV 4, 5 and 2009). We have about 500 users evenly deployed across mainland Europe and the Americas. The usage time is during normal business hours locally. We have 12 instances ranging from 2GB to 100GB.
We are migrating to a new SAN and at the same time moving to SQL 2005 from 2000. We will have 11TB of raw disk space comprised of 22 15k HDDs. We plan on using RAID 10 for data and RAID 1 or RAID 10 for the log files.
We've read a number of blogs about SQL performance tuning with regards to the log files on individual disks, but the normal assumptions refer to a single instance. We are looking for guidance on the best way to configure the container(s) for multiple log files.
Does RAID 1 provide enough performance for log files?
Should all 12 log files be on the same RAID array?
Is there a benefit to split the data files across mutliple RAID arrarys?
What is the proper block size for NAV/SQL disks?
We've ordered the NAV/SQL Performance Field Guide by Jorg Stryk and hope that the guide plus any responses here will help.