PerfMon counters

SQL Server also provides perfmon counters for the In-Memory OLTP engine; however, PerfMon is a much older technology than Extended Events and has certain limitations that prevent it from exposing all the details that Extended Events can. Be that as it may, it is still possible to collect certain information on the In-Memory OLTP engine.

A T-SQL query to return a list of the PerfMon counters that are available for the In-Memory OLTP engine would be:

SELECT object_name, 
    counter_name 
FROM sys.dm_os_performance_counters 
WHERE object_name LIKE '%XTP%'; 

Get SQL Server 2017 Developer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.