October 5, 2010 at 8:27 am
Hi all,
I was just wondering if anyone had a good source for the thresholds for the key Perfmon counters?
I was looking for something brief like;
% Processor Time < 70
Buffer Cache Hit Ration > 99
It's really as a general guideline for some investigate we are doing (sort of thing I can stick on the wall), I know a number of them but I just wondered if anyone had documented them (as guidelines).
Thanks,
Nic
October 5, 2010 at 10:17 am
This is not mine. I don't remember where it got it. Could be useful to you though.
October 5, 2010 at 10:58 am
The problem with a lot of the perfmon counters and a recommended value is that so much of it depends on the system where you're running them. For example, I/O per second, you're going to get radically different values from a SAN than from a RAID system than from a local disk than from an SSD. Which value do I list as being optimal? It's a tough call.
That said, get a copy of my book and I do provide guidelines for a lot of the standard perfmon performance counters.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2010 at 9:05 am
I look for two things is
CPU: this number can be argued as well, under 50% is good lower is even better and if higher then I look at CPU wait time.
Memory look at page life expectancy min 300 but above 1000 is best.
Disk ....like Grant said refer to his book this can complicated, when it comes to sans and DAC...lots of thing to consider...
Look at wait times 1st and then at perfmon....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply