Post reply

Performance counters Issue

  • November 27, 2007 at 2:12 pm

    #118980

    My Server is hosting SQL Server 2000 & Sql Server 2005. as we are implementing monitor tool & due to that i have to unload & then reload counters..

    So i did "unloadctr sqlctr.ini" and then try to reload "loadctr sqlctr.ini"

    i see that message counter already exsits but don't see those counter in Performon window.

    Any help to get this counters back without installing SQL Server will be highly appreciated.

    Thanks

  • November 28, 2007 at 8:02 pm

    #755218

    I have encountered this before, but I can't remember the exact solution from memory. It's something along the lines of something locking the performance monitor counters before SQL Server starts, causing the counters to not be loaded or able to be referenced.

    I think our specific problem involved monitoring software - it was getting its hooks into things before SQL Server could. Try the obvious ones - restart SQL Server, restart the entire server.


    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare

  • November 28, 2007 at 8:27 pm

    #755223

    Hi,

    Check the following http://www.sqlservercentral.com/Forums/Topic247899-5-1.aspx

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2127394&SiteID=1

    Regards,

    Ahmed

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

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