PROBLEM: Unable to add these counters (PERFMON)

Today in my system I was doing some testing on SQL Memory and I had to set perfmon counters for this. When I opened perfmon got this below window popping. 

 

Ok. First I thought of ignoring the above counters. But wait, all my SQL related perfmon counters was also missing. Hmm, that’s not good.

Fix for this issue is very simple and straight forward. Open command prompt with “Run as administrator”. We have to rebuild the perfmon counters with LODCTR. LODCTR is used to update registry values related to performance counters.

To rebuild, run the below command.

lodctr /r

Now if you open perfmon, you’ll have all your counters back :-)

Hope you find this useful

Cheers,
Naveen