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

Alert for out of workers Expand / Collapse
Author
Message
Posted Wednesday, May 29, 2013 11:03 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 11:50 AM
Points: 326, Visits: 584
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
Post #1457868
Posted Wednesday, May 29, 2013 12:32 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, September 19, 2014 12:10 PM
Points: 10,191, Visits: 13,115
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.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1457916
Posted Friday, May 31, 2013 7:25 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 11:50 AM
Points: 326, Visits: 584
So how do I tell what number to use, it does not list a Alert Number???

Date 5/29/2013 11:42:28 AM
Log SQL Server (Current - 5/30/2013 11:49:00 PM)

Source Server

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%.
Post #1458671
Posted Friday, May 31, 2013 7:42 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:22 AM
Points: 39,868, Visits: 36,213
SELECT * FROM master.sys.messages WHERE text LIKE 'New queries assigned to process on%'




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 #1458685
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse