Discussion Locked

NT Performance Monitor settings for SQL7

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like some advise on what 'Objects' and 'Counters' to monitor, and what 'scale' settings to use for each, that would give me a good overall picture of the systems performance in an MS SQL 7 environment.

2 replies

by beecee

% Processor time. Extended 80% usage is not good, would need more power.

Pages/Sec (Memory Object) You'll see some spikes, should stay always close to 0 though.

Cacher hit ratio: (Cache Manager Object) should be usually around or higher than 85%

Buffer cache Hit Ratio (Buffer manager object) higher number better.

Total Server Memory: (Memory Manager Object) Add memory if this is normally higher than the amount of RAM in the system.

Average Disk Queue Length: (physical disk object) no more than 2 times the # of spindles.

Bytes total/Sec: (Network interface object) Should be less than half your avail bandwidth.

And more http://www.windowsitlibrary.com/Content/77/15/1.html

Good Luck!
Adriana

This discussion is closed to new replies.