| Simon Hayes 2005-07-23, 7:23 am |
|
"Stephanie" <stuttle@centene.com> wrote in message
news:1122068829.573542.227430@g43g2000cwa.googlegroups.com...
>I am trying to setup a Performance Condition Alert and on this one SQL
> 2000 Server the 'Type:' drop down does not give me the option to choose
> "SQL Server performance condition alert". "SQL Server event alert" is
> the only item listed in the drop down. Is there some setting on the
> Server that I am missing that needs to be activated? I am connected
> with the SA account; Windows 2000 sp4; SQL 2000 sp2; SQL Litespeed
> (this is the only server with LiteSpeed).
>
> Thank you.
>
In some cases, it seems that the SQL Server performance counters are not
shown in the Windows Performance Monitor, so it may be that you're seeing
something similar:
http://groups.google.ch/group/micro...ec3d36b0b?hl=en
http://www.extremeexperts.com/SQL/F...erCounters.aspx
It would also be worth installing SP4 - whether or not it helps to resolve
this issue, you need at least SP3 for protection from the Slammer worm.
Simon
|