Wednesday, March 21, 2012

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

No comments:

Post a Comment