Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Correctness and stress test

Stress test SQL Server for new hardware

 Download SQLIOSim    from http://download.microsoft.com    and install on server.

When detailing the  file location , use the same as the SQL Server files. SQLIOSim will attempt to simulate the SQL Server database  IO path.

The emphasis is to hammer the system but stay under the threshold.  SQLIOSim has the capacity to throttle the outstanding operations.  It decreases the load and IO completion time is standardised

 Running Average IO duration –

Response time under stress

Date files < 5 ms is optimal

Log file – 0-2 is optimal

Total IO time – if the If the values for the Accumulators are similar for two drives, but one drive has significantly less Total IO Time, then the latter performs much  because it was able to service the same I/O in less time.

 

Number of times IO throttled – lower the better

For performance testing check Disk IO performance and SQLIO

 

Author: Jack Vamvas (http://www.sqlserver-dba.com)

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.