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
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"
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?
What is your page file size and utilization?
ASKER
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
What is showing as:
Total Memory
Available
System Cache
PF Usage
ASKER
in order;
3669384 total mem
1447106 available
945376 system cache
1.96gb PF usage
3669384 total mem
1447106 available
945376 system cache
1.96gb PF usage
ASKER
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?
ASKER
It wont let me make the paging file any bigger that 4096
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thank you that is what I needed.