Performance Monitor Counters for SQL Server

Performance Monitor Counters for SQL Server – Ready Reference

Hi Friends,

Here is a wonderful piece of document that can help you find the availability of any Performance Monitor Counter for SQL Server in any version starting from SQL 2005.

Many a times, when we are working with various versions of SQL Server, especially in the role of DBA, and when we have a need to work with perfmon counters, we struggle to figure out whether a particular counter exists in a specific version. We have to check the availability of counters by running performance monitor on that specific Windows box – a simple by tedious/time consuming process.

This document lists down all the SQL Server counters and their availability in SQL Server 2005, 2008, 2008 R2, 2012 and 2014. Here is a screenshot:

SQLServer_perfmon_counters_ready_ref

A nice document that can sit on your desktop 🙂

Download it from our Resource Center.

More such documents coming soon! Subscribe to our newsletter to get notified when we publish such resources.

By Amit Bansal|2020-09-03T17:22:09+05:30December 22nd, 2014|SQL Server|1 Comment

About the Author: Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: https://sqlmaestros.com/amit-bansal/ He is on Twitter: https://www.twitter.com/A_Bansal

One Comment

Rick Willemain January 3, 2015 at 2:23 pm - Reply
Thank you very much.

Performance Monitor Counters for SQL Server – Ready Reference