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