A forum for sharing what I have learned about SQL Server over many years of thought, contemplation and practice
Translate This Page
Translate this page
Browse by Tags
Tagged Content List
How to create a Deadlocked Scheduler Scenario at will
First, please do not try this on your production server, because it will actually work. Second, this example is to illustrate how Deadlock scheduler issues can and do occur with the goal of increasing your understanding of the problem. Over the years of working with SQL Server, I learned that to understand...
24 Apr 2013
Meditation: The Tao of the Deadlock Scheduler in SQL Server
Just thought I would summarize the concept of a SOS Scheduler and a Deadlocked Scheduler since many have inquired over the years for a brief summary of these concepts UMS/SOS Scheduler in SQL Server Since SQL Server 7.0, SQL Server has used its own scheduling mechanism, called UMS (User-mode...
14 Dec 2012
Tasks, Workers, Threads, Scheduler, Sessions, Connections, Requests – what does it all mean?
With this meditation I attempt to explain what some of the more common concepts that get used with SQL Server thread management and scheduling are. Parable: There was an all-powerful, but humble and benign Master, whom the workers revered and humbly served. The master accepted requests from other...
13 Dec 2012
Meditation: Is IOCP listener actually listening?
What is the IOCP Listener? The IOCP listener is a dedicated system thread that accepts incoming connections to SQL Server. It is a SQL Network Interface (SNI)-layer thread that listens for TCP/IP sockets or Named Pipes traffic (VIA is going away but still in the code). When a connection comes in,...
12 Dec 2012
Page 1 of 1 (4 items)
© 2014 Microsoft Corporation.
Privacy & Cookies