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: http://support.microsoft.com/kb/300956/en-us

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

cd\windows\system32

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)

image

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 http://blogs.technet.com/b/pfelatam/archive/2011/08/08/sql-performance-counters-are-missing.aspx

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

image

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s