Hi, I'm looking for a fix to an issue where performance counters are missing from SQL 2016 (SP2).
All SQL related counters are available in the OS i.e. Perfmon but only and small amount related to XTP are available in SQL itself e.g. if I run the following
SELECT * FROM sys.dm_os_performance_counters
It returns 57 rows and all counters deal with XTP, everything else is missing.
Any suggestions for a fix greatly appreciated.
Thanks in advance.