Chapter 2. SQL Server Execution Model and Wait Statistics

It is impossible to troubleshoot SQL Server instances without understanding its execution model. You need to know how SQL Server runs tasks and manages resources if you want to detect bottlenecks in the system. We will cover those questions in this chapter.

First, the chapter will describe SQL Server’s architecture and major components. Next, it will discuss SQL Server’s execution model and introduce you to the popular troubleshooting technique called Wait Statistics. It will also cover several data management views commonly used during troubleshooting. Finally, it will provide you an overview of Resource Governor, which you can configure to segregate different workloads in the system.

SQL Server: High-Level Architecture

As you know, SQL Server is a very complex product that consists of dozens of components and subsystems. It is impossible to cover all of them here, but in this ...

Get SQL Server Advanced Troubleshooting and Performance Tuning now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.