Extended Events - SQL Server 2016

Well I have playing with Extended Events in SQL Server 2016 and its really good.





























As you can see from above, Extended Events is located in the same place as in SQL Server 2014 within the 'Management' tab.

If you didn't know, Extended Events has been designed to replace SQL Profiler and Trace Flags within SQL Server and SQL Profiler will be disappearing in future versions of SQL Server so you really need to understand Extended Events if you want to troubleshoot and new features that appear in SQL Server going foward.

To set up an new Extended Event session to troubleshoot your system, you can do the following

1) Right click the 'Sessions' tab within the Extended Events section and select 'New Session Wizard'
2) Selecting this will open up a wizard screen that will take you through setting up the extended event.

Once your Event has been set-up, it will appear in the 'Sessions' section.

If you didn't select the option to start the extended event session when you created the extended event, you can start it now by right-clicking the event and selecting 'Start Session'

You can view live event data that happens within your system by selecting the extended event and selecting 'Watch Live Data'

That is it for setting up Extended Events Session, very easy to do and a vast improvement to SQL Trace and SQL Profiler.