SQL Server I/O for Thought
Following are the links specifically relating to best practices for setting up disk I/O for SQL Server workloads.
Predeployment I/O Best Practices - http://sqlcat.com/whitepapers/archive/2007/11/21/predeployment-i-o-best-practices.aspx
Complete I/O Best practices whitepaper - http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx
Storage Top 10 Best Practices - http://sqlcat.com/top10lists/archive/2007/11/21/storage-top-10-best-practices.aspx
Tools – below are links to tools that can aid you in the testing of I/O for SQL Server workload.
- SQLIO Disk Subsystem Benchmark Tool (Microsoft Download Center)
- How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem (Knowledge Base article)
- IOMeter (IOMeter site)
- diskpar.exe – OS built-in tool used to align disks