Blog Post

SQL Server Blog
1 MIN READ

SQL Server Management Studio Provides–“XE Profiler”

BobDorr's avatar
BobDorr
Icon for Microsoft rankMicrosoft
Feb 23, 2022

Moved from: bobsql.com

 

Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Quick XE Trace’ capabilities. The feature is available in the latest SQL Server Management Studio (SSMS) release.

 

Despite the deprecation of SQL Profiler several years ago, as well as various documents and blogs pointing out the older trace facilities shortcomings and performance impact on the SQL Server, SQL Profiler is still a top choice of SQL Server Developers and DBAs.  The ‘quick’ ability kept surfacing as a reason for using SQL Profiler.   The ‘quick’ part was defined as getting live data on the DBA’s or Developer’s screen with just a few clicks.

 

The new tree node (XE Profiler) provides that ‘quick’ ability.   The ‘Quick XE Profiler’ displays live events using the simple ‘Launch Session’ menu selection.  The templates capture common events and leverage XEvent enhanced view capabilities to display the event data.

Published Feb 23, 2022
Version 1.0
No CommentsBe the first to comment