Solved

physical disk time, memory, disk queue length numbers

Posted on 2007-03-30
2
382 Views
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?
0
Comment
Question by:yanci1179
2 Comments
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 500 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

0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 18835473
What's total RAM? disks usage? controller cache? RAID configuration?
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Problem with SqlConnection 5 115
PL/SQL query 14 46
SQL Restore Script - Syntax Error 8 75
separate column 24 20
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now