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%'; 
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.144.100.237