Improving I/O performance on SQL Server 2000

Tags:
I/O errors
Performance monitoring
SQL Server 2000
SQL Server performance
I have SQL Server 2000 SP4 running on an Intel Xeon 2.33 GHz CPU with a 2GB RAM server. We have a total of eight workstations connected to this server, and Performance Monitoring says that the Avg. Disk Queue Length is at about 20 when all users are working concurrently. My tempdb logs are at 500MB on my C: drive. Is there a specific way, given this information, that I can improve my I/O performance?

Answer Wiki

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

If your disk queues are that high you may need to look into adding additional disks to the server.

You will also want to look at your indexing on your databases. If you don’t have the tables indexes correctly this will cause the disks to work harder than they need to.

He is right, what kind of drive configuration do you have? Your ldf files and tempdb files should be on different arrays. If this is just one drive array and you can’t add to it your only hope will be to add more memory, but as your DB grows the drive will always be a bottleneck

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

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