asked on

SQLServer Performance Counters not visible despite lodctr sqlctr.ini

The performance monitor counters for our SQL server are not visible in the Performance Object drop down in Performance Monitor. I'm running SQL Server 2000 SP3 on a Microsoft Cluster in an active-passive mode. The other node of the cluster is running Exchange 2003. After googling and searching this site I've already verified that that there is not a disabling entry in the registry. I have also run:

unlodctr mssqlserver followed by: lodctr sql2k_directory\binn\sqlctr.ini and verified the presence of the sqlctr.ini file. After moving the SQL Cluster Group to the other node and returning it, the monitors still are not present.

Is there something I'm overlooking here that is preventing access to the sql specific counters?

Thanks

ASKER CERTIFIED SOLUTION

ShogunWade

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

hcca

ASKER

I tried this just now. I moved the SQL group to the other node. Rebooted the SQL node. When it came back up the SQL services moved back to their original node. The monitors are still not present. There is a Database and Database ==> Instances listed but no SQLServer listings.

ShogunWade

I thing SQL logs in the event log if it fails to create the counter objects. can you check if there is anything reported there.

hcca

ASKER

I find multiple entries in the application log like this:

The configuration information of the performance library "C:\WINNT\system32\w3ctrs.dll" for the "W3SVC" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted.

This occurs for w3ctrs.dll, ftpctrs2.dll, infoctrs.dll and aspperf.dll. Based on the event ID of 2003 I found the following links on Microsoft's site:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q300956
and
http://support.microsoft.com/kb/267831/EN-US/

I am suspecting that I'll need to rebuild the basic counters and then add the others back in. Does it seem logical that if these are screwed others will be also? There is not event listed specifically for the MSSQL counters.