I have increase the memory of my sql server 2000 SP3 from 2GB to 6GB due to high disk usage.
Can you explain why, even with my smaler memory i had a cache hit ratio of 100% but disk que lenth of more than 2000?
With adding more memory, the disk queu length has decreasedbut the % disk busy remains very high.
We have a IBM blade server with a disk attached to the EMC san
dababase size is:
1 of 69GB
1 of 69gb
1 of 19gb
1 of 8gb
How can i check if i have to much or to little memory?
/attached is a report of my memory and disk usage (The swap has been done on 02 july at 10 AM