SQL Server monitor counters cannot be accessed

Add the objects to the PerfMon counters on the remote machine

SQL Server objects need to be accessable via PerfMon (Windows Performance tool) for SiteScope to get the counters.

Add the objects to the PerfMon counters on the remote machine and the SQL Monitor in SiteScope will work.

There are many cases where SQL Server’s counters are missing. In this FAQ, it is assumed that the installation of SQL Server 2000 is a default installation.

There are many reasons for which the SQL Server counters will disappear, such as Permission, Server Crash, Registry Modification, and Virus. To work around these symptoms, please take the following actions:

1. Check if you have full permissions to access the local folder C:\Program Files\Microsoft SQL Server\MSSQL\. Make sure that you can access this folder or your current account is located in local administrator group.

2. Make sure there is no third-party application that add keys to the registery to disable the performance counters. You can open the registry to check if there is a key named “Disable Performance Counters” valued “1” in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance. If it exists, delete it.

3. Under the registery key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance, make sure the following keys with these values do exist. If not, create a new one and add the value.

“Library”=” C:\PROGRA~1\MICROS~3\MSSQL$~1\BINN\SQLCTR80.DLL”
“Collect”=”CollectSQLPerformanceData”
“Open”=”OpenSQLPerformanceData”
“Close”=”CloseSQLPerformanceData”
“Last Counter”=dword:

Note:
The “Last Counter,” “Last Help,” “First Help,” “WbemAdapFileSignature,” “WbemAdapFileTime,” and “First Counter” values can vary between SQL Server installations.

READ  SiteScope 11.33 integration with BSM 9.2x, APM 9.30 and OMi 10.12 require redeployment of SITESCOPE.ZIP package

Leave a Comment