Post reply

missing performance counters

  • 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?

  • 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.

  • 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

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply