SQL Perfmon Counters Are Missing

Issue:
SQL server performance counters not displayed in performance monitor tool (PerfMon.exe)

Products:

Power Monitoring Expert

SSMS

Environment:
SQL Server 2008 and later

Resolution:

One resolution is to restart the server. If you encounter issues after restarting the server, reapply Windows OS service packs/updated.

If restarting the server does not fix the issue, this problem can be fixed by following these three steps:

1) Unload the counter
A) Open the command prompt, type in the following:
- For Default instance:
unlodctr.exe MSSQLServer
- For named instance:
unlodctr MSSQL$

2) Load Counter
A) In the Command Prompt, type the following
For the default instance:
lodctr.exe "\binn\sqlctr.ini"
For named instance:
lodctr.exe "\binn\perf-MSSQL$sqlctr.ini"

3) Reboot the server

If your problem is that the Analysis Services counters can't be found, then use the following:

A) Open the command prompt and type in the following:

unlodctr.exe MSSQLServerOLAPService
B) Then type in the following: lodctr.exe "\binn\msmdctr.ini"

C) Reboot the server

If you get an unexpected error message, look it up at msdn.microsoft.com. Note: this tip applies only to non-clustered SQL Servers.

Recommendation:

If you are using an older version of PME, consider upgrading to the latest version for improved protocol support and security. For assistance with integration or upgrades, contact Schneider Electric Technical Support at: pmo.support@se.com