SQL Server Performance

why is this wait?

Discussion in 'SQL Server 2005 General DBA Questions' started by avipenina, Apr 8, 2008.

  1. avipenina New Member

    Hi,
    i set in my servers a trigger that if a database is created or deleted then send email. now everything is working fine,but when the email is sent to me i see in the sql server waits this wait
    BROKER_RECEIVE_WAITFOR
    WAITFOR(RECEIVE conversation_handle, service_contract_name, message_type_name, message_body
    FROM ExternalMailQueue INTO @msgs), TIMEOUT @rec_timeout
    how can i disable this wait.(i must say that after a minute or two this waits disappear)
    Thx
  2. MohammedU New Member

  3. avipenina New Member

    can i prevent this from happen?

Share This Page