Post reply

SQL performance counters Missing

  • March 2, 2006 at 1:26 pm

    #152798

    I built a SQL2000 sp4 on a Windows2003 R2 (x64) machine. I cannot

    find the SQL performance counters when running the NT Performance Monitor,

    however, I can pull every counters from the master..sysperfinfo table.

    Any help would be greatly appreciated.  

     

     

     

     

     

  • March 2, 2006 at 1:40 pm

    #624462

    Is this you are looking for the first time for performance counters or all of the sudden it disappeared?

    If it is not enabled, you need to enable this...

    Reloading the SQL Server Counters

        At command prompt, locate the current folder to C:\Program Files\Microsoft SQL Server\MSSQL\BINN 

    and execute as "lodctr sqlctr.ini"

    and see if appears? if not let me know we have alternate ways to get it.

    Thanks-Mubeen

  • March 2, 2006 at 2:06 pm

    #624471

    Before posting this, I had run this script and got message "Counters for MSSQLServer are already installed".

    Please advise.

    Thanks

     

     

  • March 2, 2006 at 3:39 pm

    #624487

    Have you tried bouncing the OS?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • March 2, 2006 at 8:51 pm

    #624516

    No, I have not.  Can you tell me how to do it?

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

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