Here is another popular lab from Hands-On-Lab library: SQL Server Wait Types – Part 1.
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 work load. In this lab we will observer four wait types that frequently occur in SQL Server. In this lab, we’ll learn PAGEIOLATCH, PAGELATCH, WRITELOG and ASYNC_NETWORK_IO wait types.
Exercise 1: PAGEIOLATCH
Exercise 2: PAGELATCH
Exercise 3: WRITELOG
Exercise 4: ASYNC_NETWORK_IO
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.