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!