Getting SQL Server Performance counters is not available on one of the instance that is being monitored by Spotlight for SQL Server Enterprise.
Other instances on the same server show the data with no issues.
Severity Alarm Raised Message Snoozed By Snoozed Until
Information Missing SQL Performance Counters 11/29/2010 3:03:45 PM SQL Server performance counters are not available
The instance has lost SQL Server Performance Counters. This happens from time to time at the discretion of SQL Server.
To re-enable SQL Server Performance Counters try the suggestions below locally on the machine with the problem please:
1. Forcibly unload the counters to be sure there is a clean state at the command prompt:
unlodctr.exe MSSQL$DRMS
2. Now load then again: lodctr.exe <SQL Server Path>\binn\sqlctr.ini
3. Reboot the machine;
4. Run the following to parse all the performance libraries on the system and refresh the Performance Counter Classes on the problematic machine:
wmiadap /f
5. When Performance Counters enabled, the SQL below executed in MASTER DB against monitored server should show perf counters data:
select * from sysperfinfo
If it returns no data, it might be a Microsoft SQL Server issue that is outside of our capability to resolve.
