Infrastructure at your Service

Category Archives: Development & Performance

Stéphane Haby

SQL Server 2012: new perfmon counters

By | Development & Performance | One Comment

I have read some blog postings concerning the new perfmon counters, but I have not seen really extensive overviews yet. In this post, I would like to present not only what is new, but also what has changed (or not) and how to find it. The first step is to select all objects in SQL2008R2 and SQL2012 from the view sys.dm_os_performance_counters. Remarks: All object or counter definitions from this post come from msdn. Objects comparison The…

Read More