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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment