SCOM Instance summary 2012 SQL dashboard No Data showed

It happened to me that I get this on my dashboard (No Data) sql instance summary 2012. At first I was thinking something is wrong with MP. But, after studying event logs I found some errors 10102 like this.

errors 10102

It means that there is no performance counters in windows server that MP is looking for. How this happens I don’t know but to get it back (base performance counters) read this KB:

I was going easy way and restored first base performance counters (if any were deleted):


lodctr /R

Performance counters for SQL are in different location so how to get it. Go to SQL installation folder and follow this commands:

cd C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn (go to binn folder of sql installation)

unlodctr MSSQLSERVER  (unload performance counter that maybe left installed)

lodctr perf-MSSQLSERVERsqlctr.ini (load performance counters for MSSQLSERVER default instance. For named instance you should use this format perf- MSSQL$NombreInstanciasqlctr.ini)


After that restart Remote registry and Performance Logs & Alerts  if necessary. Restart management agent on server in question and wait for some time to get data in SCOM dashboard for more detail about restoring SQL performance counters visit

I hope I helped and that you get yours performance data in SCOM dashboard.