May 29, 2013 at 11:03 am
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
May 29, 2013 at 12:32 pm
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
Consultant - Straight Path Solutions
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
May 31, 2013 at 7:25 am
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%.
May 31, 2013 at 7:42 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply