physical disk time, memory, disk queue length numbers

Posted on 2007-03-30
Medium Priority
Last Modified: 2008-01-09
Theaverage disk queue length for server  is currently 49.
 Physical disk time for server  is currently 165.31%.
Available operating system memory on server is currently 7 MB.

Newbie, sorry, was wondering what the above figures mean and how do they effect SQL Server 2000?
Question by:yanci1179
LVL 30

Accepted Solution

nmcdermaid earned 2000 total points
ID: 18833747
They indicate that your SQL Server is definitely suffering performance issues due to the disk I/O system being insufficient.

Accordong to general guidlines you need to get your queue down to under 10 at least.

Do some of these things:

1. Defrag your disk
2. Stop the SQL Service and defrag your disk if possible
3. Add some more disk drives and spread your data files, indexes and logs over them
4. Turn off any software compression

LVL 23

Expert Comment

ID: 18835473
What's total RAM? disks usage? controller cache? RAID configuration?

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

619 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