Sample Header Ad - 728x90

SQL Server Long Running Transaction - WAITFOR(RECEIVE conversation....DatabaseMail)

5 votes
1 answer
3245 views
I have recently implemented an Agent Job which checks SQL Server every 10mins for any long running queries and if detected it will send out a mail to recipients with the information. However since putting this in, I notice alot of the below query and wonder if this is something I should be concerned about:
WAITFOR(RECEIVE conversation_handle, service_contract_name, message_type_name, message_body FROM ExternalMailQueue INTO @msgs), TIMEOUT @rec_timeout
Understand its from Database Mail and the wait info is (1x: 62093ms)BROKER_RECEIVE_WAITFOR but should I need to worry or simply exclude it from the alerting. Looking at it via sp_whoisactive can see that the open_transaction count is 1 and the status is suspended. Any help is appreciated.
Asked by rdbmsNoob (459 rep)
Jan 18, 2021, 06:21 PM
Last activity: Jun 10, 2022, 12:44 PM