Lowering a high average disk queue length on a SQL Server

Tags:
SQL Server tables
We have a small table on our SQL Server with a high Avg. Disk Queue Length. The typical methods to fix this, such as fragmentation for the indexes and reorganizing the indexes, do not help. What other solutions are there?

Answer Wiki

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

It sounds like you need to look at your execution plans and review your execution plans. You may need to add some indexes to the database.

Fire up SQL Profiler and filter based on the DiskIO value greater then 1000. If that gives you to much data increase the number. Then run these commands manually and review the execution plan. Anything which is doing a table scan, index scan or clustered index scan needs to have the indexes reviewed and possible additional indexes created.

If you are seeing only seeking it may simply mean that your database load has outgrown the capacity of your disk array.

Discuss This Question:  

 
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