SQL Server Performance

Performance Monitor - missing coumters

Discussion in 'Performance Tuning for Hardware Configurations' started by Aviel, Nov 10, 2003.

  1. Aviel New Member

    For some reason I can't see the SQL Server counters in my Performance Monitor. I run it from my browser in a client machine. Also, and it might be connected to the previous problem, I can't see the alert type of 'SQL Server performance conditon' in the dropdown type field in 'New Alert' Window, when I try to create a new alert in MMC.

    Any help please ?

    Aviel Iluz
    Database Administrator
    Pacific Micromarketing
    Melbourne Australia
    www.pacmicro.com.au
  2. satya Moderator

  3. Aviel New Member

    Thanks satya

    Aviel Iluz
    Database Administrator
    Pacific Micromarketing
    Melbourne Australia
    www.pacmicro.com.au
  4. satya Moderator

    BTw what is the level of service pack on Windows & SQL?

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  5. biged123456 New Member

    Check your SQL errors logs for this error:
    Performance monitor shared memory setup failed: -1

    I believe it was introduced with SQL 2000 Sp3 and should be fixed in Sp4. There is a hotfix available now. It appears that if you are running perfmon and have the SQL counters loaded when you start SQL, they disappear. Reloading the couters without rebooting does not work. Only rebooting (with or without re-applying the counters) will get them back. This naturally happens more on clusters since one node can remain up while SQL fails over or is cycled. I have tested the fix on several stand-alone machines and 3 clusters (SQL 2000 sp3 and sp3a) and have found no problems yet.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;812915
  6. satya Moderator

    Appreciate the response and correction about SQL 2K is still in SP3a, long way to go for Sp4.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page