SQL Server threads architecture

SQL Server retrieves threads from Windows. The SQL Server configuration setting max worker threads (set at instance level) determines how many threads will be retrieved. SQL Server has its own internal scheduling system, independent of the scheduling performed by the operating system. Instead of using Windows threads directly, SQL Server creates a pool of worker … Continue reading SQL Server threads architecture

Wait wait wait…

Let's talk about why we have to wait and how to understand the wait types. Paul Randal in his post Wait statistics, or please tell me where it hurts said: A thread is using the CPU (called RUNNING) until it needs to wait for a resource. It then moves to an unordered list of threads … Continue reading Wait wait wait…