SQL Server Wait Types – Part 2

Home/Administration, SQL Server/SQL Server Wait Types – Part 2

SQL Server Wait Types – Part 2

$15.00 $4.00

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

Categories: ,

Description

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

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.