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.
The “Last Counter,” “Last Help,” “First Help,” “WbemAdapFileSignature,” “WbemAdapFileTime,” and “First Counter” values can vary between SQL Server installations.