Here is another popular lab from Hands-On-Lab library: Monitoring SQL Server with Extended Events.
SQL Server Extended Events (Extended Events) is a general event-handling system for server systems. The Extended Events infrastructure supports the correlation of data from SQL Server, and under certain conditions, the correlation of data from the operating system and database applications. This lab is divided into three exercises explaining how to monitor page split, contention and waits using extended events.
Exercise 1: Monitor Page Split
Exercise 2: Monitor Tempdb Contention
Exercise 3: Monitor Waits
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.
Happy Learning – The Practical Way.