Use the SSMS XEvent Profiler
The XEvent Profiler is a SQL Server Management Studio (SSMS) feature that displays a live viewer window of extended events. This overview describes the reasons for using this profiler, key features, and instructions to get started viewing extended events.
Why would I use the XEvent Profiler?
Unlike SQL Profiler, XEvent profiler is directly integrated into SSMS and is built on top of the scalable Extended Events technology in the SQL engine. This feature enables quick access to a live streaming view of diagnostics events on the SQL server. This view can be customized and those customizations can be shared with other SSMS users as a .viewsettings file. The session created by XE Profiler is less intrusive to the running SQL server than a similar SQL trace would be when using SQL Profiler. This session can be customized by the user as well, using the existing XE session properties UI or by TSQL.
This feature is only available on SQL Server Management Studio (SSMS) v17.3 or later. Make sure you are using the latest version. You can find the latest version here.
To access the XEvent Profiler, follow these steps:
Open SQL Server Management Studio.
Connect to an instance of the SQL Server Database Engine or localhost.
In Object Explorer, find the XE Profiler menu item and expand it by clicking the '+' sign.
Double-click Standard if you want to view all extended events in this session. Click T-SQL if you want to view the logged SQL statements. If a session is not already created, a session is created for you.
You can now view your Extended Events.
We are listening: If you find something outdated or incorrect in this article, such as a step or a code example, please tell us. You can click the This page button in the Feedback section at the bottom of this page. We read every item of feedback about SQL, typically the next day. Thanks.