As an application, SQL Server may request system resources as it executes a user query and waits for its request to be completed.  Waits are represented by SQL Server wait statistics. SQL Server tracks wait information any time that a user connection or session_id is waiting. This wait information is summarized and categorized across all connections so that a performance profile can be obtained for a given workload. In this lab we will observe four wait types that frequently occur in SQL Server. In the first exercise we will look at RESOURCE SEMAPHORE wait types. In the second exercise we will look at the THREADPOOL wait type. In the third exercise we will look at PREEMPTIVE wait types and in the fourth exercise we will cover CXPACKET wait type.

Subscribe to Download


Version1.0
Download6
File Size641.67 KB
Create DateSeptember 7, 2016
Last UpdatedSeptember 12, 2016
SQLServer Plan Caching Recompilation and Reuse
SQL Server Wait Types Part 1