Friday, May 9, 2008

Perfmon Counters

I was viewing screencast DAT306 of Teched 2007 by Kevin Kline. He suggests the following counters as the most important when monitoring a Sql Server Test in Perfmon.

  1. Pages/sec
  2. Bytes Total /sec
  3. % Disk Time
  4. Avg Disk Queue Length
  5. % Processor Time
  6. Full Scan/sec
  7. Buffer cache hit ratio
  8. Transactions per sec
  9. Log growths
  10. User connections
  11. Average latch wait time
  12. Number of deadlocks per second
  13. Average wait time ms
  14. Memory grants pending
When you add the counter you can choose the server name to be monitored. It is highly desirable not to monitor on the same server you are testing; as the act of monitoring may skew the results.

There are many performance objects - so how do we know which to use - what is useful inour scenario? The best advise is to learn from other people, hence above Kevin Klines's suggested list.

No comments: