performance condition alerts are not working

Hi,

I've a problem with my alerts on a SQL 2000 SP3.

I can not add sql server performance condition alerts. The table master..Sysperfinfo is empty.
And the existing ones doe not work properly.

I've already tried unlodctr & lodctr en rebooted the server more than once. But it didn't work.

Can someone help me with this problem ? thanks !!!When you open up performance monitor, do you have any performance counters that work?|||the other performance counters are working. It seems that only sql performance counters aren't working.|||If you go to www.microsoft.com and type in "sql server missing performance counters", the first two posts deal with this issue. See if those help you out.|||I work with sql 2000 sp3 and those solutions apply to sql 6.5 and 7.0. But I do have installed a hotfix of Mdac.
Should I try the workaround described in http://support.microsoft.com/default.aspx?scid=kb;en-us;246328 , although it doesn't mention sql 2000 ?|||I'd check a previous thread (http://www.dbforums.com/t1003397.html) for ideas!

To borrow a line from a signature at SQLTeam.com:

<yoda>
Use the search feature you must. Answers you will find.
</yoda>

-PatP|||I've checked the previous threads and tried some ideas (unlodctr and lodctr) but it didn't work.
can anyone give me another solution ?

THANKSsql

Performance Condition Alert Type

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."Stephanie" <stuttle@.centene.com> wrote in message
news:1122068829.573542.227430@.g43g2000cwa.googlegr oups.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