SQL Server Tools - Recomendations On Stress Testing and I/O Testing On New SQL Server

Question

Post reply

SQL Server Tools - Recomendations On Stress Testing and I/O Testing On New SQL Server

Viewing 7 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

vikingDBA SSCertifiable Points: 5356 More actions · Answer 1

Here is a great article explaining how to interpret the results and best practices on running SQLIO.

http://technet.microsoft.com/en-us/library/cc966412.aspx

And another interesting article:

Troubleshooting Slow Disk I/O in SQL Server

http://blogs.msdn.com/b/askjay/archive/2011/07/08/troubleshooting-slow-disk-i-o-in-sql-server.aspx

Nadrek SSC-Insane Points: 20039 More actions · Answer 2

Even stranger is that despite the 8/22/2012 date, it still claims to be version 1.0, and it still only officially supports up to Windows 2003 and XP (not 2003 R2, mind you).

I checked - it's byte for byte 100% identical with the previous download (which is a true pity - it very much needs a pseudorandom write mode to test incompressible data on storage with compression and deduplication capabilities)

YSLGuru SSC-Insane Points: 21669 More actions · Answer 3

vikingDBA (8/24/2012)
Here is a great article explaining how to interpret the results and best practices on running SQLIO.
http://technet.microsoft.com/en-us/library/cc966412.aspx
And another interesting article:
Troubleshooting Slow Disk I/O in SQL Server
http://blogs.msdn.com/b/askjay/archive/2011/07/08/troubleshooting-slow-disk-i-o-in-sql-server.aspx

Thanks for the link

Kindest Regards,

Just say No to Facebook!

Scott D. Jacobson SSCertifiable Points: 6149 More actions · Answer 4

One more, I stumbled across this today while looking for something else on TechNet. Remembered this thread and thought it was worth sharing:

http://gallery.technet.microsoft.com/scriptcenter/Storage-IO-Performance-d628bad9

YSLGuru SSC-Insane Points: 21669 More actions · Answer 5

Scott D. Jacobson (9/6/2012)
One more, I stumbled across this today while looking for something else on TechNet. Remembered this thread and thought it was worth sharing:
http://gallery.technet.microsoft.com/scriptcenter/Storage-IO-Performance-d628bad9

Thanks

Kindest Regards,

Just say No to Facebook!

Patrick Canute DSouza Newbie Points: 7 More actions · Answer 6

Hello YSLGuru,

I too faced the same problem and while searching i came across the following.

1.Hammerora (Open Source Load Tester Tool)

•Initially built for Oracle but now supports SQL Server too.

•http://hammerora.sourceforge.net/ (Main Page)

•http://hammerora.sourceforge.net/hammerora_mssqlserver_oltp_v2.7.pdf (SQL Server Configuration Guide)

2. Additional tools as seen on the following link

http://sqlserverio.com/2012/08/16/free-tools-for-testing-sql-sever/

From,

Patrick Canute D'Souza.

YSLGuru SSC-Insane Points: 21669 More actions · Answer 7

Thanks for the recommendations Patrick.

Kindest Regards,

Just say No to Facebook!