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 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%';
Now that we have explored the possibilities that memory-optimized tables offer, it would be fantastic to be able to somehow evaluate our existing databases. Ideally, this evaluation would show how many tables or stored procedures could potentially be converted from traditional disk-based objects into ultra-fast memory-optimized objects.
Luckily for us, Microsoft has also...