Performance Monitor – missing coumters | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Performance Monitor – missing coumters

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
Refer this linkhttp://sql-server-performance.com/forum/topic.asp?TOPIC_ID=687 if you’re using cluster. In any case unload and reload the counters by running the following commands :
unlodctr
lodctr
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Thanks satya Aviel Iluz
Database Administrator
Pacific Micromarketing
Melbourne Australia
www.pacmicro.com.au
BTw what is the level of service pack on Windows & SQL? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
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
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
]]>