Post reply

SQL process that's always in activity monitor as suspended status..

  • March 22, 2013 at 3:26 am

    #291410

    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

    #1599695

    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

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

  • March 22, 2013 at 4:13 am

    #1599703

    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