Hands-On-Lab: SQL Server Wait Types – Part 2

Hello Friends,

Here is another popular lab from Hands-On-Lab library: SQL Server Wait Types – Part 2.

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.

Exercise 1: RESOURCE SEMAPHORE
Exercise 2: THREADPOOL
Exercise 3: PREEMPTIVE
Exercise 4: CXPACKET

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.