Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

All schedulers on Node 0 appear deadlocked due to a large number of worker threads waiting on LCK_M_S. Process Utilization 0%. and sql server gets restarted

Posted on 2008-10-24
4
Medium Priority
?
1,399 Views
Last Modified: 2012-06-21
Hi ,
We have biztalk server which gets restarts now and then with the following error.
All schedulers on Node 0 appear deadlocked due to a large number of worker threads waiting on LCK_M_S. Process Utilization 0%. After googling  I found that it is schedular deadlock issue 17884 eventid. Can you please let me know how to investigate and mitigate.
0
Comment
Question by:Veereshvnashi
2 Comments
 

Author Comment

by:Veereshvnashi
ID: 22802385
Can somebody please look into the issue.
0
 
LVL 32

Accepted Solution

by:
Brendt Hess earned 1000 total points
ID: 22838352
Be aware of the equation number of hosts * max thread-pool size * number of CPUs = potential DB sessions. Too many connections all trying to read and write to your MessageBox at the same time can overwhelm SQL Server, locking up the system and reducing your throughput dramatically.  According to research I found, you should try setting the max threads per cpu down to (say) 50 and see how that affects your processing.  You can check the following link for instructions on how to do this:

http://msdn.microsoft.com/en-us/library/aa561380.aspx
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question