An XEvent a Day (3 of 31) – Managing Event Sessions
- by Jonathan Kehayias
Yesterdays post, Querying the Extended Events Metadata , showed how to discover the objects available for use in Extended Events. In todays post, we’ll take a look at the DDL Commands that are used to create and manage Event Sessions based on the objects available in the system. Like other objects inside of SQL Server, there are three DDL commands that are used with Extended Events; CREATE EVENT SESSION , ALTER EVENT SESSION , and DROP EVENT SESSION . The command names are self...(read more)