Post reply

Performance counters on Windows Server 2003

  • September 17, 2008 at 4:39 am

    #127528

    Hi,

    At my place of employment we have a SQL 2005 installation thats running on Windows Server 2003. I set up performance counters in the past using the Performance Monitor tool to gauge how the server box was performing. I noticed recently that those counters don't exist any more on the server. Perfmon just shows numeric performance objects like 1150 and numeric counters like 1152. Is the perfmon library corrupt? How can i get the real objects and counters to show again so that i can gauge performance again.

    Please help.

    Tendayi

  • September 17, 2008 at 5:55 am

    #872937

    Hi,

    Try stopping and then restarting the SQL Server service, I'm sure I read somewhere that the perfmon counters re-register themselves on startup.

    Are there any perfmon related events in the event log that might point to where the problem lies?

  • September 18, 2008 at 12:34 am

    #873407

    I ran the command lodctr.exe /r from the command prompt and it reloaded the counters with the real names. The event viewer did not show much.

    Thanks.

  • September 18, 2008 at 1:43 am

    #873418

    Please don't cross post. It just wastes people's time and fragments replies.

    Answered here:

    http://www.sqlservercentral.com/Forums/Topic570887-145-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 18, 2008 at 2:07 am

    #873431

    Sorry. Noted. Was actually an admin question but posted it under development.

  • June 4, 2009 at 9:43 am

    #1004735

    Had the same issue. - Used the lodctr command. Worked like a charm..

    Thank you.

    Steve

  • December 16, 2010 at 7:39 am

    #1263455

    EXCELLENT, it works like a magic

    Adnan

Viewing 7 posts - 1 through 6 (of 6 total)

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