We are facing some issue with Sql Server 2008 R2 Database Mail Queue functionality using "msdb.dbo.sp_send_dbmail" system stored procedure. After some time email functionality goes into suspended mode. SQL server executes a SP named "msdb.dbo.sp_readrequest;" which goes into suspended mode. This happen most of the time and we get dead locks alert
I adjusted the database mail executable minimum lifetime ( in seconds ) from 600 to 10 and this problem seems to have dissapear.
Databasemail object on SSMS --------> Configure databasemail ----------------->View or change system parameters--------->Database mail executable minimum lifetime change it to 10 seconds
.
Hi,
ReplyDeleteThanks for the tip. I'm experiencing the same problem at the moment.
I would have expected you to increase the database mail executable minimum lifetime so that it takes longer for the database mail process to shutdown. But you did the opposite. Could you please explain how the database mail executable minimum lifetime works?
Thank you.
Kenneth