Finding a process taking forever in the suspended state, I wondered what it could be.
Fortunately Irina Tudose had already done the hard work for me. It is a process used by the mail procedures in msdb. She recommends changing the default value for DatabaseMailExeMinimumLifeTime to resolve this.
See also
SQL Server: Why a Session With sp_readrequest Takes so Long to Execute
UPDATE msdb.dbo.sysmail_ configuration
SET paramvalue = 60 --60 Seconds
WHERE paramname = ' DatabaseMailExeMinimumLifeTime '
No comments:
Post a Comment