Enabling Performance Counters in SQL Server 2000
This is an interesting problem we had in the
Newsgroup. There are specific case where SQL Server's counters were missing. In
this FAQ we assume that the installation of SQL Server 2000 is a default
There are many reasons when the SQL Server counters will disappear, such
as Permission, Server Crash, Registry Modification and Virus. To work around
the symptom, please take the following actions:
1. Check if you have full permission 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
2. Make sure there is no third-party application which add keys in
Register to disable the performance counters.You can open the registry to check
if there is a key named "Disable Performance Counters" valued "1" in:
If it exists, please delete it.
3. Under the register key:
Make sure the following keys with the value DO EXIST. If not, please create a
new one and add the value.
# Note # : The "Last Counter", "Last Help", "First
Help", "WbemAdapFileSignature", "WbemAdapFileTime", and "First Counter" values
can vary between SQL Server installations.
"Library"=" C:\PROGRA~1\MICROS~3\MSSQL$~1\BINN\SQLCTR80.DLL "
4. Unload the SQL Server Counters. In command line, execute "unlodctr
MSSQLServer" (Without quotation, the same as below)
5. Reloading the SQL Server Counters
(a) In command line, locate the current folder to
C:\Program Files\Microsoft SQL Server\MSSQL\BINN
(b) Execute "lodctr sqlctr.ini"
6. Stop SQL Server Services and Restart the Services
(a) In command line, execute "net stop mssqlserver"
(b) Execute "net start mssqlserver"
(Or you can perform it in Service Manager or in System
7. Open Perforam Monitor to check if the counters appear
(a) In command line, execute "perfmon"
(b) Add and check if the counter appear
PS: Note this FAQ is based on the conversation in the