Windows Performance Monitor Counters List


Now that we understand how to use Performance Monitor let's take a look at some of the counters that we should be using to monitor the health of our servers and databases.  I like to break the counters down into two distinct categories when it comes to monitoring the health of a system:

  • OS/Server counters
  • Database/Instance counters

Breaking the counters up this way can usually help to narrow down the root cause of an issue faster.  For example, you could be experiencing a slow response from the queries in your database but there could in fact be some other system related issue with disks or CPU that is actually causing the poor performance.  In the rest of this section, we will look at the counters that are available in each of these categories and for each category answer the following questions.

  • Which counters should you collect?
  • What do the counters mean?
  • What are good and bad values?
  • What should you do when you see "X" value?
Additional Information

Comments For This Article

get free sql tips
agree to terms