Mssing SCCM Performance Counters

I was facing this strange issue of not able to find all those SMS_**** performance montor counters.

Tried the LODCTR commands and rebooted the server, but it did not help.

Even went into every SMS folder under c:\windows\inf, and run the command to rebuild SMS Counters

Lodctr /R:<filename>. But it didnt work.

Finally, Microsoft support provided me this solution that worked.

Open cmd prompt (run as administrator).

Go to the installation location of ConfigMgr.

Eg:

C:\Program files (x86)\Microsoft Configuration Manager\bin\i386>

Type in the following:

Perfsetup.exe /install /siteserver:<ServerName> SMS_WSUS_SYNC_MANAGER

Eg:

Perfsetup.exe /install /siteserver:SCCMCEN SMS_WSUS_SYNC_MANAGER

Check the PErfsetup.log for any errors.

Once I followed the above steps I was able to see all the Perf Counters for SMS.

For MSSQLServer counters:

Open this registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSSQLSERVER\Performance

Check the value of PerfINIFile.

Open cmd prompt.

Go to SQL Bin folder - C:\Program Files\Microsoft SQL Server\...Bin

Run this command lodctr sqlctr.ini

And lodctr perf-MSSQLSERVERsqlctr.ini (value found for PerfINIFile).

Restart SQL service.