Alert for out of workers

  • Since there is not a Performance Tuning section ... for SQL 2008, posting this question here.

    We had a period, today, when our server was out of workers for over 5 min (this shows up in the SQL server log). Is there some way to get the server to send out an e-mail when this happens (I guess this would have to be done on the server side, since SQL Server is out of workers)

    David

  • You should be able to setup a SQL Agent Alert based on the error number that fires when the error occurs. I'm pretty sure SQL Agent will have a worker thread even when this error occurs.

  • So how do I tell what number to use, it does not list a Alert Number???

    Date5/29/2013 11:42:28 AM

    LogSQL Server (Current - 5/30/2013 11:49:00 PM)

    SourceServer

    Message

    New queries assigned to process on Node 1 have not been picked up by a worker thread in the last 240 seconds. Blocking or long-running queries can contribute to this condition, and may degrade client response time. Use the "max worker threads" configuration option to increase number of allowable threads, or optimize current running queries. SQL Process Utilization: 0%. System Idle: 97%.

  • SELECT * FROM master.sys.messages WHERE text LIKE 'New queries assigned to process on%'

    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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply