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
1,332 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
4 Comments
 

Author Comment

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

Accepted Solution

by:
bhess1 earned 250 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

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…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

772 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