Database Mail

I am just setting up database mail on a new server. It is up and
working correctly, however when I run a trace looking for things that
have a very long running duration I see this statement over and over.
I can't find any documentation on what it is, besides part of database
mail. Is this normal or did I miss configure something?
Durations of 30-40 seconds, 0 CPU time, 40-50 reads
exec sp_readrequest @.receive_timeout=600000
IT is configured to send emails to our corporate Exchange server.The procedure is issuing a WAITFOR(RECEIVE ...) waiting for a mail message
to be enqueued for sending. As such, the duration shows all the time the
procedure is stays in the WAITFOR(...) as execution time. This is not real
execution (CPU and I/O consumption), so you should just ignore it.
HTH,
~ Remus
<cploessel@.gmail.com> wrote in message
news:1165877369.144745.176210@.16g2000cwy.googlegroups.com...
>I am just setting up database mail on a new server. It is up and
> working correctly, however when I run a trace looking for things that
> have a very long running duration I see this statement over and over.
> I can't find any documentation on what it is, besides part of database
> mail. Is this normal or did I miss configure something?
> Durations of 30-40 seconds, 0 CPU time, 40-50 reads
> exec sp_readrequest @.receive_timeout=600000
>
> IT is configured to send emails to our corporate Exchange server.
>|||Not sure what this has to do with the original question. This sp reads a
service broker queue to obtain mail to send. It suspends until a mail
message appears on the queue. The duration is the length of time the queue
has no messages to send so it could easily have a duration of an hour or
more. When it's waiting for a message to appear it doesn't use resources
other than an idle execution thread.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<cploessel@.gmail.com> wrote in message
news:1165877369.144745.176210@.16g2000cwy.googlegroups.com...
>I am just setting up database mail on a new server. It is up and
> working correctly, however when I run a trace looking for things that
> have a very long running duration I see this statement over and over.
> I can't find any documentation on what it is, besides part of database
> mail. Is this normal or did I miss configure something?
> Durations of 30-40 seconds, 0 CPU time, 40-50 reads
> exec sp_readrequest @.receive_timeout=600000
>
> IT is configured to send emails to our corporate Exchange server.
>