Sunday, January 25, 2009

SQL Server Performance Counters Missing Disappear Not Visible - Try unlodctr.exe MSSQLServer use lodctr sqlctr.ini

One of our Server was having memory problem, when I started Performance Monitor none of SQL Server counters where available. To resolve this kind of issue, Perform below steps.

Step 1:
Open Command Prompt and type "unlodctr.exe MSSQLServer" and hit Enter

Output:
Removing counter names and explain text for MSSQLServer
Updating text for language 009

Step 2:
Locate the Binn folder of SQL Server Installation and look for file named sqlctr.ini. Now copy the complete path of this ini. For example :
D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlctr.ini

Step 3:
Go to command prompt and type
lodctr.exe "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlctr.ini"

Output:
No error message.

Incase you are not using double quotes in the path name above you will then get below error message "Unable to find initialization file Files\Microsoft". So Don't forget to enclose the path with quotes.

Now go to Start --> Run --> Type perfmon.msc and check for SQL Counters and you will be able to see it... If not just give a Restart (???). This issue seems to be coming in cluster servers after failover.

Links:
How to manually rebuild Performance Counter Library values

No comments:

Post a Comment

Please do not spam!