just for kicks you could put a trace on all processes using msdb. Could be
quite interesting.

-----Original Message-----
From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed] Wednesday, December 04, 2002 9:56 AM
To: LazyDBA.com Discussion
Subject: RE: SQLAgent - Alert Engine


Meg,

SQL Server supports an alert mechanism which responds to various specified
events by mailing or paging various specified individuals. Typical events
might be errors with a high severity, a specific error, or a specific
performance threshold. These can be very useful.

This the function of the connection you have noticed. As far as I know, the
only way to disable it is to disable SQL Server Agent - which loses
scheduling (including backups, housekeeping etc.). I think that some example
alerts are enabled when SQL is first installed; if that is the case, you
might be able to reduce IO by disabling them.

Charles

> -----Original Message-----
> From: Meg Hardy [SMTP:[Email Address Removed] Sent: Wednesday, December 04, 2002 12:18 PM
> To: LazyDBA.com Discussion
> Subject: SQLAgent - Alert Engine
>
> Hello!
>
> Everytime I run sp_who2 I notice that there is a connection running
> ProgramName SQLAgent - Alert Engine. The DiskIO is always really high
> (3021522). Does anyone know how to bring this down or if it is necessary
> to
> be that high and it will be impossible to lower it?
>
> Thanks!
> Meg
>
>
>
> **********************************************************************
> DISCLAIMER
> Any opinions expressed in this email are those of the individual and not
> necessarily of Mondial Assistance (UK) Ltd. This email and any files
> transmitted with it, including replies and forwarded copies (which may
> contain alterations) subsequently transmitted from the Company, are
> confidential and solely for the use of the intended recipient. If you are
> not the intended recipient or the person responsible for delivering to the
> intended recipient, be advised that you have received this email in error
> and that any use is strictly prohibited.
>
> If you have received this email in error please notify the IT support desk
> by telephone on +44 (0)208 2393984 or via email to
> [Email Address Removed] including a copy of this message.
> Please then delete this email and destroy any copies of it. Thank you.
>
> Mondial Assistance (UK) Ltd
> Mondial House
> 102 George Street
> Croydon
> CR9 1AJ
>
> Mondial Assistance (UK) Ltd Registered in England No.1710361 Registered
> office as above
> **********************************************************************
>
>
> ________________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs SkyScan
> service. For more information on a proactive anti-virus service working
> around the clock, around the globe, visit http://www.messagelabs.com
> ________________________________________________________________________
MS Sql Server LazyDBA home page