create-an-extended-events-session.md

title	Create an Extended Events Session | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	database-engine
ms.topic	conceptual
ms.assetid	34b1e95a-a80e-4aca-9201-abde47f2ca74
author	mashamsft
ms.author	mathoma
manager	craigg

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

In This Section

Create an Extended Events Session Using Query Editor

Create an Extended Events Session Using the Wizard (Object Explorer)

Create an Extended Events Session Using the New Session Dialog