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 - https://sqlcat.com/whitepapers/archive/2007/11/21/predeployment-i-o-best-practices.aspx

Complete I/O Best practices whitepaper - https://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx

Storage Top 10 Best Practices - https://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