{"id":997,"date":"2019-03-21T06:00:49","date_gmt":"2019-03-21T13:00:49","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=997"},"modified":"2019-03-20T15:30:45","modified_gmt":"2019-03-20T22:30:45","slug":"extended-events-in-azure-data-studio","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/extended-events-in-azure-data-studio\/","title":{"rendered":"Extended Events in Azure Data Studio"},"content":{"rendered":"

I was prompted to dig into using Extended Events in Azure Data Studio (ADS) after the latest release came out from the Tools Team this past Monday.\u00a0 After you download<\/a> and install ADS, and connect to an instance<\/a>, you’ll want to navigate to the Extension Manager (blue box in image), then scroll through the list to find SQL Server Profiler (purple box in image):<\/p>\n

\"Azure<\/a><\/p>\n

Azure Data Studio Extension Manager<\/p>\n

 <\/p>\n

NOTE:<\/strong> Even though the extension is named SQL Server Profiler, it is using Extended Events<\/em>.\u00a0 The documentation states explicitly:<\/p>\n

“The SQL Server Profiler extension provides a simple SQL Server tracing solution similar to SSMS Profiler except built using XEvents.”<\/p><\/blockquote>\n

To clarify, the extension in ADS is like XEvent Profiler in Management Studio<\/a> (which also is built using Extended Events).\u00a0 The name “SQL Server Profiler” is confusing, as this is not the same tool (UI) that’s been available since SQL Server 7.0.<\/p>\n

To install the extension, click on it, and then select Install.\u00a0 Once it’s installed you can select Reload and it will move into the top half of the window under Enabled.\u00a0 Notice that when you select the extension, information about how to use it also appears.<\/p>\n

\"SQL<\/a>
SQL Server Profiler Extension Installed<\/figcaption><\/figure>\n

 <\/p>\n

The easiest way to start using Extended Events in ADS is to use Alt+P (for Windows) or Ctrl+Alt+P (for macOS). You can also click on the Manage icon in the bottom left, select Command Palette… and then type Profiler. Using either method, you’ll get a Connection window to connect to the instance:<\/p>\n

\"Connection<\/a>
Connection panel<\/figcaption><\/figure>\n

 <\/p>\n

Once you’ve connected, you’ll be prompted to select what type of session to create, and there are three options currently available:<\/p>\n

\"XE<\/a>
XE New Session<\/figcaption><\/figure>\n

 <\/p>\n

This is where things get interesting.<\/p>\n

There are three template options:<\/p>\n