WMI issue with SQL Server 2014

November 21, 2014

Issue: I installed sql2014 enterprise edition with cu3 in the following machine.  Just as a disclaimer I have been running a SQL 2012 edition on the same host without any issue with WMI counters.

capture1

I could not see any WMI counters for sql2014.  I tried perfmon.exe and also querying:

SELECT * FROM sys.dm_os_performance_counters
SELECT * FROM sys.sysperfinfo

Then I snipped through SQL server error log and found this:

Cannot query value ‘First Counter’ associated with registry key ‘HKLMSYSTEMCurrentControlSetServicesMSSQL$SQL2014Performance’. SQL Server performance counters are disabled.

So I went to the registry and added a new key with value 4090 under  HKEY_LOCAL_MACHINESYSTEMCurrentControlSetservicesMSSQL$SQL2014Performance

capture2

Restarted the SQL engine and now I could use the WMI counters.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.