Hello ,for one of server we faced below error
WAITFOR RECEIVE conversation_handle service contact anem message type name message body from ExternalMailqueue into msgs TIMEOUT rec timeout
Wait type is:
can you please assist to let us know the reason and remady of the same.
asked May 03, 2012 at 01:54 PM in Default
See http://ask.sqlservercentral.com/questions/42858/problem-with-waits.html and http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx and http://blogs.msdn.com/b/sql_service_broker/archive/2008/12/01/service-broker-wait-types.aspx
It appears to be benign, and, unless you're seeing other problems, not likely to be anything to worry about.
answered May 03, 2012 at 02:24 PM