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,374 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 

Author Comment

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

Accepted Solution

by:
Brendt Hess 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

623 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