You are here: Re: Performance Condition Alert Type « MsSQL Server « IT news, forums, messages
Re: Performance Condition Alert Type

Posted by Simon Hayes on 07/23/05 15:11

"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/microsoft.public.sqlserver.server/msg/3630b59ec3d36b0b?hl=en
http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация