How can I use the SQL stress test to determine the maximum capacity of my SQL subsystem?

Question

I am looking for an article on the Stress disk subsystem for SQL Server. Therefore, I can improve bandwidth management! I already know the basics, but I'm looking for an “how” for dummies who want to set up and do some reports and trends using Excel!

thank

Answer 1

Google provides: http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO If you conduct any stress tests in the SAN, make sure that they do not affect the performance of another production server.