April 19, 2004 at 1:08 pm
I have just run DBCC PerfMon and found that the CACHE HIT RATIO reading was 0.
Network Reads and Network Writes are accumulating.
Can anyone explain this?
April 22, 2004 at 8:00 am
This was removed by the editor as SPAM
April 22, 2004 at 8:10 am
How much memory do you have in your server.
I dont believe dbcc perfmon will give an accurate cache hit ratio in configurations where AWE is enabled.
Have tried monitoring the server the performance monitor using the specific sql objects? I wouldn't advise running this continually it eats resources.
If you need a cheap and easy monitoring tool try sqlcheck it's free and works fine.
If you're not using above 4gb of ram then beats me unless you've got the max memory set to some really low value.
Dave
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply