This article is contributed. See the original author and article here.

If you find the SQL Server related performance counter objects are missing, you can try below steps to get it back


 


For example, my instance name is STD2016, and now open the command window with Administrator


 


1. unload the counter.  cd to the Binn folder of your instance, by default, the folder path should be


C:Program FilesMicrosoft SQL ServerMSSQLXX.INSTANCENAMEMSSQLBinn


And then run unlodctr command, if you are using the default instance, just use


unlodctr MSSQLSERVER


For me,  it is unlodctr MSSQL$STD2016, the format is MSSQL$INSTANCENAME


YueJ_7_0-1616467375739.png


2. Load the counter.  Under the Binn folder you will see a file begins with “perf-MSSQL$”, the name format is


perf-MSSQL$INSTANCENAMEsqlctr.ini.


For default instance, use


lodctr perf-MSSQLSERVERsqlctr.ini


For mine, it is


lodctr perf-MSSQL$STD2016sqlctr.ini


YueJ_7_1-1616467605075.png


3. Restart the remote registry key service


NET STOP “Remote Registry” & NET START “Remote Registry”


YueJ_7_2-1616467694450.png


4. Close the performance counter and open it again, you will be able to see it


YueJ_7_3-1616467735719.png


 

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

%d bloggers like this: