Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL process that's always in activity monitor as suspended status.. Expand / Collapse
Author
Message
Posted Friday, March 22, 2013 3:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 5:23 AM
Points: 147, Visits: 325
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
Post #1434164
Posted Friday, March 22, 2013 3:45 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 42,771, Visits: 35,870
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1434172
Posted Friday, March 22, 2013 4:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 5:23 AM
Points: 147, Visits: 325
ah ok, cheers for explaining that Gila

ill leave it be then :)
Post #1434182
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse