Windows Performance Monitor Counters List



By:
Overview

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

Last Update: 3/13/2019





More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download


get free sql tips
agree to terms


Learn more about SQL Server tools