Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL 2005,  Very Slow AVG Disk Queue Length 632

Posted on 2009-02-12
2
Medium Priority
?
420 Views
Last Modified: 2013-11-24
Server is W2k08 Enterprise, with 16GB ram.  We have a custom DB that runs on SQL 2005.  All sites (6) avg 6 users each site, connect via TS throught VPN.  DB gets very slow, and Avg Disk Queue Length is very high.  I have read about enabling PAE on the server, but I am worried about potential problems with pritner drivers or other drivers.  Can anyone give advice?
0
Comment
Question by:SSaulsjla
2 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 23630366
Please find the link below through which you can identify the reasons for Very high AVG Disk Queue Length.

http://www.iishacks.com/index.php/2008/09/12/high-avg-disk-queue-length-and-finding-the-cause/

Make sure you have appropriate indexes and the queries are tuned out so that it can be reduced in the other way around.

You can give a try on PAE, probably you may or may not  face some issues in performance or Boot failure. on those situations disable PAE.

http://www.microsoft.com/whdc/system/platform/server/PAE/PAEdrv.mspx
0
 

Author Closing Comment

by:SSaulsjla
ID: 31546369
I appreciate the information.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question