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
Naveen
