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
Reviews
There are no reviews yet.