Export (0) Print
Expand All

Create an Extended Events Session

You can create an Extended Events session by using the Query Editor, or you can create a session in Object Explorer. In Object Explorer, Extended Events provides two user interfaces you can use to create, modify, and view event session data — a wizard that guides you through the event session creation process, and a New Session UI that provides more advanced configuration options. You can create Extended Events sessions to diagnose SQL Server tracing, which enables you to resolve issues such as the following:

  • Find your most expensive queries

  • Find root causes of latch contention

  • Find a query that is blocking other queries

  • Troubleshoot excessive CPU usage caused by query recompilation

  • Troubleshoot deadlocks

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft