missing performance counters

• MBHblows

  SSCommitted

  Points: 1614

  More actions

  November 10, 2003 at 4:21 am

  #106548

  After installing sp3 I seem to be missing perf counters for sql. Does anyone else have this problem?

• paulhumphris

  Hall of Fame

  Points: 3496

  More actions

  November 10, 2003 at 4:53 am

  #481390

  I have also lost the Performance Counters for SQL on one of my servers, although it was upgraded to SP3 (along with my other servers) a while ago and therefore do not think this problem is linked to SP3.

  Any solution to restore the Performance Counters would be gratefully received.

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  November 10, 2003 at 5:00 am

  #481391

  A performance counters bug was introduced in SP3. Have a look at the following link:

  http://support.microsoft.com/?id=812915

• phani kumar gotety

  Ten Centuries

  Points: 1213

  More actions

  February 13, 2005 at 8:06 pm

  #541982

  Try to unload and reload the performance counters

  1. execute "unlodctr mssqlserver" to unload the performance counters

  2. In command line, change the directory to C:\Program Files\Microsoft SQL Server\MSSQL\BINN and Execute "lodctr

  sqlctr.ini"

  3. Stop and Start the SQL server service

  Now check the perfmon

  This should reload the counters