Home > SQL Server, SQL Server 2017 > XE Profiler / Extended Events Profiler – New SQL Server Management Studio Feature

XE Profiler / Extended Events Profiler – New SQL Server Management Studio Feature


SQL Server Management Studio v 17.3 introduces new feature called “XE Profiler” or “Extended Events Profiler”, This will be the obvious replacement for SQL Server Profiler which was part of SQL Server Tools since SQL Server 7.0

Out of the box, XE Profiler supports the following options

capture20171011111042838

TSQL template provide simple details such as Event Sequence, Name of the Event, Query Text, Session ID, Time Event occurred

capture20171011111119585

Standard Template provide more details such as Client Application Name, User Name, CPU Time, Logical Reads, Writes, Duration

capture20171011111514648

You can Pause and Resume profiling using these options

capture20171011111834646

Clear Data option is enabled only when profiling is on and running, I wish this should be enabled in stopped state as well to cleanup

One of my personal favorite feature is Bookmarks

capture20171011112054442

We can setup Bookmarks on statements which you want to review later using “Toggle Bookmark” option from Toolbar or Context menu, we can navigate between Bookmarks using “Previous Bookmark” and “Next Bookmark” options, We can clear the Bookmarks using “Clear All Bookmarks” option, it would be nice to have a warning when we use this option, so that accidental cleanup of all bookmarks can be avoided

Find” is a handy option to search for specify details such as query text

capture20171011112751489

We can also customize the Search for specific column by changing the Look In

capture20171011112956258

Also we have option to customize the list of columns we want to see as well

capture20171011113059525

We also have option to create Merged columns by combining up to 5 columns

capture20171011113242153

We can save the changes made to display settings and reuse the previously saved settings as well

capture20171011113544245

Filters option enables us to run the profiler to target specific database or application or by specific username

capture20171011113748783

We can also setup Time based filter and Fields supported in filter are as follows

capture20171011114012086

capture20171011114031275

Hope you find this article helpful !!!

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: