Link to home
Create AccountLog in
Avatar of Raquelfournier
Raquelfournier

asked on

Avg disk ques at 100% all day

I have SQL 2000 server that is at 100% avg disk que all day. Can tell me why the que would be so high? thanks
Avatar of Delphineous Silverwing
Delphineous Silverwing
Flag of United States of America image

You probably have a bottleneck at your drive controller or the drives themselves.  Turn on performance monitoring of your storage volumes and monitor your users activity around the times the queue averges 100% - This will help point you to where improvements are needed, be it faster harder, more cache, or whatever.
"faster harder should have been "faster hardware"
Avatar of Raquelfournier
Raquelfournier

ASKER

Ok i did notice I cant increase the page file on the server. Do I need the /3GB switch for that?
The /3GB switch is to allow windows to use more physical memory if you have the memory to support it.  Do you have 4 GB of memory?

What is your page file size and utilization?
it wont let me make the page file biger that 4096
Press <Ctrl>+<Shift>+<Esc>, then go into the Performance tab.

What is showing as:
   Total Memory
   Available
   System Cache
   PF Usage
in order;

3669384 total mem
1447106 available
945376 system cache
1.96gb PF usage
anybody got a clue?
Making your paging file larger would not help this issue.  Have you started performance monitoring on SQL, controller, and the volumes?
It wont let me make the paging file any bigger that 4096
ASKER CERTIFIED SOLUTION
Avatar of Delphineous Silverwing
Delphineous Silverwing
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Thank you that is what I needed.