SQL I/O Best Practice

585 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Rick Martinez
    What other way can I create a benchmark for storage performance?
    585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following