You can control different aspects of how an event session behaves by setting the event session options as part of the CREATE EVENT SESSION DDL . The default settings for the event session options are designed to handle most of the common event collection...

Thanks to some help from SQL MVP Adam Mechanic , the Extended Events blog is now being cross posted on SQLblog.com. Except for the first two posts ( welcome message & Reading event data 101 ), these blogs will be identical so read whichever site you...

If you explored extended events to any degree you’ve already discovered that when you read the targets you get your event data back as XML. First things first, lets clear up a popular misconception; event data is not stored as XML in the targets, it’s...

If you haven’t gotten a chance to explorer Extended Events yet, then you’ll probably want to read about it first in Books Online. You can start at the SQL Server Extended Events topic and work from there. From the BOL topics you’ll learn that Extended...