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](https://sqlworldwide.com/wp-content/uploads/2014/11/capture1-300x133.jpg)
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](https://sqlworldwide.com/wp-content/uploads/2014/11/capture2-300x123.jpg)
Restarted the SQL engine and now I could use the WMI counters.