Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Performance Condition Alerts

Author  Topic 

nishithrn
Yak Posting Veteran

58 Posts

Posted - 2003-07-01 : 03:46:03
Hello,

I have SQL 2000 installed on one of my servers. I am trying to configure SQL Performance Condition Alerts. On going to New Alert->Type option, I don't find the SQL Server Performance Condition Alert option. In the drop down list box I find only one option i.e. SQL Server Event Alert. However, incase of SQL 7.0 Both the above options are available. Is it that SQL 2000 does not support SQL Performance Condition Alert..??

Pls. help. Tx in advance !!!

Regards


tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-07-01 : 12:41:12
I have SQL Server 2000 here and I see the SQL Server Performance Condition Alert option. What service pack are you using for SQL Server? I've got service pack 2 plus the cumulative security patches installed.

Tara
Go to Top of Page

REDDY
Starting Member

43 Posts

Posted - 2003-07-01 : 13:10:57
SQL2000 does have this option,May be SQLServer Performance Counters are not installed properely may be a problem of MDAC

Go to Top of Page

REDDY
Starting Member

43 Posts

Posted - 2003-07-01 : 13:31:09
Refer this link

http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14287

Go to Top of Page

nishithrn
Yak Posting Veteran

58 Posts

Posted - 2003-07-03 : 04:33:56
Thanks for ur reply...

I have sql2k with sp3 installed with the cumulative pack. Also, as REDDY suggests SQL Performance Counters are not installed properly, can you pls. suggest me as to how to install the same.

Regards

Go to Top of Page

REDDY
Starting Member

43 Posts

Posted - 2003-07-07 : 10:41:37
Try Unload/Load the sql server counters ,for details follow this Microsoft Knowledge base article


http://support.microsoft.com/default.aspx?scid=kb;en-us;196657

Go to Top of Page
   

- Advertisement -