Home > IT Answers > Storage > SQL I/O Best Practice
Rick Martinez
585 pts.
 SQL I/O Best Practice
iSCSI SAN Server, SQL 2005, SQL Server 2005, SQL Server administration, Windows Server 2003
I just inherited a SQL SERVER 2005 32-bit attached to a SAN Server. I want to use SQLIO for performance testing and stress testing. The database is in production. Would it be a good idea to run SQLIO on a production sql server during non-work hours?

Software/Hardware used:
SQL SERVER 2005, SERVER 2003 32-bit, XIOTECH 7000 SAN
ASKED: December 17, 2010  10:11 PM
UPDATED: December 20, 2010  2:05 PM
RELATED QUESTIONS
Answer Wiki:
You can run SQLIO against the server, but it will impact the performance of the SQL Server, and anything else which shares spindles on the SAN with the SQL Server, and possibly anything else on the SAN as you flood the SAN cache. It is usually recommended to not run SQLIO on production servers.
Last Wiki Answer Submitted:  December 18, 2010  12:42 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What other way can I create a benchmark for storage performance?

Rick Martinez
 585 pts.