SQL Server Performance Counter are Missing

 dans Sites Microsoft par

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

2. Load the counter.  Under the Binn folder you will see a