Extended Events Profiler (XE Profiler) in SSMS 17.3

Starting in SSMS version 17.3, Microsoft has launched a new feature: Extended Events Profiler (XE Profiler). This new feature is in a very early stage, but it looks like the first step by Microsoft to replace the SQL Profiler which is already deprecated.

 

Two different session templates appear by default under the new ‘XE Profiler’ in object explorer: ‘Standard’ and ‘TSQL’. They are not XE sessions by itself. They are templates provided by Microsoft to start with. If you double-click one of them, a new live data window opens, capturing the server activity.

When we open the live data window, SSMS automatically creates a new XE session based on the template. The name of the session is a fixed one, SSMS will check if a session with this name already exists, and create it if not.

 

The templates capture a fixed set of events and we can’t create new templates on this early stage of the feature. The table below shows the events each template captures.

 

Standard TSQL
Existing_connection Existing_connection
Login Login
Logout Logout
Rpc_complted Rpc_starting
Sql_batch_completed
Sql_batch_starting Sql_batch_starting

 

We can set filters onto the session using the filter menu.

Although we can’t create new templates or change the existing ones, we can make a workaround: If we edit the sessions used by the templates, changing the events and filters, the templates will use these edited sessions.

 

On this early stage, the final result of this feature is similar to the ‘Watch Live Data’ XE feature and a lot less powerful than SQL Profiler, due to the lack of customization. However, this feature seems to be the first stage for SQL Profiler replacement since it was set as deprecated and, due to that, it deserves our attention.

Leave a Comment

Your email address will not be published. Required fields are marked *