Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Missing SQL Counters- Unload/Reload Does Not Work

Author  Topic 

DBADave
Constraint Violating Yak Guru

366 Posts

Posted - 2005-02-17 : 10:23:03
I've posted this question about 8-10 months ago and had no luck with the suggestions so I thought I would try again.

We have one SQL Server 2000 server that had the perfmon counters disappear one day. Since then I've tried lodctr with no luck.

unlodctr mssqlserver
lodctr \\SQLServer path\binn\sqlctr.ini

I've also verified the existence of various registry entries in HKEY_LOCAL_MACHINE.

The following entries exist.

HKEY_LOCAL_MACHINE
\Software
\Microsoft
\WindowsNT
\CurrentVersion
\Perflib
\009

HEKY_LOCAL_MACHINE
\SYSTEM
\CurrentControlSet
\Services
\MSSQLServer
\Performance
\Library: REG_SZ: C:\PROGRA~1\MICROS~3\MSSQL\BINN\SQLCTR80.DLL

sqlctr.ini exists in C:\Program
Files\Microsoft SQL Server\MSSQL\BINN.

I don't see any error messages in event viewer.

Any suggestions besides reinstalling SQL Server?

Thanks, Dave
   

- Advertisement -