March 22, 2013 at 3:26 am
hi all
there is one process thats always in our sql activity monitor at suspended status..
The application is DatabaseMail90 - running against msdb, wait type BROKER_RECEIVE_WAITFOR
I can kill the process fine, but it appears pretty quickly again
is it from a dodgy mail profile in sql?
how can i find its source?
it does not seem to cause any performance issues, but id like to clear it up all the same
any ideas?
mal
March 22, 2013 at 3:45 am
It's in the suspended state because it's waiting for a mail to send. When a mail is sent, it will run, send the mail then go back to waiting for a mail to send.
When you're looking at waits and suspended processes, ignore the system processes, they usually are in a waiting state, because they're waiting for work to do. This is not a problem, if the mail process was running continually, I'd be rather worried.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2013 at 4:13 am
ah ok, cheers for explaining that Gila
ill leave it be then 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply