Here is another popular lab from Hands-On-Lab library: SQL Server Extended Events Basics.
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. In the first exercise, we will explore different components of extended events. In the second exercise we will create an event session and will also look at system catalog views and DMV to view configuration of an existing event session. In the third exercise, we will look at different targets available in the extended event and in the fourth and final exercise of this we will look at some exciting features available in the SQL Server Management Studio extended event GUI.
Exercise 1: Extended Event Objects
Exercise 2: Extended Event Sessions
Exercise 3: Extended Events Targets
Exercise 4: Extended Events Graphical User Interface
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.