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.

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