How can I use SQLIO Stress Test to define the max capacity of my SQL subsystem ?

Question

I am looking for an article about Disk Subsystem Stress for SQL Server. So I can do better capacity management ! I already know the basis but I am looking for an "how to" for dummies who wants to install and do some reporting and trending using Excel !

Thanks

Answer 1

Google delivers: http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO If you are doing any kind of stress testing on a SAN, be sure not to affect other production server's performance.

Answer 2

Maybe you've already come across these ones during your research, but here it goes:

SQLIOSim available for download

How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem

Storage Performance Reference Architecture

If you are subscribed to SQL Server Magazine, you have access to his article:

SQLIOSim