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