Home Forums SQL Server 2005 Administering SQL process that's always in activity monitor as suspended status.. RE: SQL process that's always in activity monitor as suspended status..

  • 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