We help IT Professionals succeed at work.

Windows 2003 Disk Queue at 100%

13,602 Views
Last Modified: 2012-06-27
In Performance Monitor, the Average Disk Queue is flatlining at 100%.  Obviously, users are complaining about slow response times when accessing data.

Is there a quick way to find out which process is hammering the disks?

I've restarted the SQL services and print spooler.
Comment
Watch Question

Author

Commented:
Sorry - it's Average Disk Queue Length.
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
" "Avg. Disk Queue Length" is a measure of the items waiting to be written into the disk. It is displayed as number of write operations in the cue, not percent. "

Should have read:

" "Avg. Disk Queue Length" is a measure of write operations waiting at the disk to be written. It is displayed as number of write operations in the cue, not percent. "

Not "Items" but "Write Operations"

Sorry.

Commented:
More likely than not the bottleneck is caused by SQL and your disk layout.  I have listed some links below on monitoring the server and best practices:
http://sqljunkies.com/Article/D1B7C756-4725-4D31-A53D-C0A47976E6BB.scuk
http://msdn2.microsoft.com/en-us/library/ms175903.aspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops6.mspx

Commented:
Avg. Disk Queue Length is the average number of both read and write requests that were queued for the selected disk during the sample interval.

Generally you want to seperate your log files from your database files and you do not want to put the logs on a RAID5, use RAID10 instead.  Any RAID setup will work for the database files.

Author

Commented:
Points awarded.

Solution in the end:

We have GFI Mail Archiver and we recently put another Exchange server into our domain for another site.  Since GFI Mail Archiver wasn't licensed for all the extra users, we are assuming that the email data was trying to archive but couldn't due to the lack of licenses.  Once we took the email archive databases offline, the disk queue went back to normal.

Author

Commented:
Why is it recommended that the log files be separated from the database files?  Do you mean on another RAID array or logical drive?

Commented:
Different physical disk (be it RAID or not).  Transaction logs are accessed sequentially, database files are random.  If DB files are located on different disks then you have parallel I/O.
I've experienced this a few times and the AntiVirus scanner was causing this, even in normal realtime protection, changing priority settings helped. When experiencing heavy disk I/O remember to check the AV also!

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.