{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Schneider Electric USA Website

Welcome to our website.
How can we help you today?
SQL Perfmon Counters Are Missing

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

Products
Any product that uses SQL

Environment
SQL Server 2008 and later

Resolution

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

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

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

2) Load Counter
A) In Command prompt type the following
For 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 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 is for non-clustered SQL Servers only.

Schneider Electric USA

Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.