![\"Deadlocks](\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2016\/02\/Deadlocks-with-Extended-Events-1.png\")
<\/a><\/p>\nClick next on the Introduction screen and give the Session a name. I\u2019m going to name this session Deadlocks:<\/p>\n
Click next. On the Choose Template screen you can choose a predefined template (like Profiler) or you can create your own events by choosing \u201cDo not use a template\u201d. For this post, let\u2019s create our own:<\/p>\n Click next and you\u2019ll see hundreds of events (like Profiler). We only want to capture deadlock data so let\u2019s scroll down to the very bottom and choose xml_deadlock_report. Click on the event and click the right arrow to move it into the Selected Events box:<\/p>\n You can choose other events if needed, but for the simplicity of this post I\u2019m just going to use this one. Click next. The Capture Global Fields page allows us to select what fields we want to capture. These are unique to each event selected. For this example, I\u2019ll choose the following fields:<\/p>\n Click next. On this page you can apply filters if needed. I\u2019ll setup a filter so that I only capture data from the RollTide database. There are hundreds of different filters that can be configured so that you don\u2019t pull back data that is not needed:<\/p>\n Click next to the Session Data Storage page. This page allows you to save data to a file or work with only the most recent data. I don\u2019t want to keep thousands upon thousands of events so I\u2019ll choose \u201cWork with only the most recent data\u201d<\/p>\n The next page summarizes all the options we have selected. You can also script this session if you need to create it on other servers or save it for later. Click Finish to create the new session.<\/p>\n The last page allows you to start the session immediately and watch live data. For this post, I\u2019ll choose both:<\/p>\n You should see the new session under Extended Events and the Live Data tab should appear:<\/p>\n Once a deadlock occurs it should show the deadlock in the Live Data window:<\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n