{"id":74634,"date":"2017-10-20T10:09:32","date_gmt":"2017-10-20T10:09:32","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=74634"},"modified":"2021-08-24T13:39:21","modified_gmt":"2021-08-24T13:39:21","slug":"extended-events-xe-profiler-ssms","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/sql-server\/database-administration-sql-server\/extended-events-xe-profiler-ssms\/","title":{"rendered":"Extended Events Profiler (XE Profiler) in SSMS"},"content":{"rendered":"

Starting in SSMS<\/strong> version 17.3, we have an interesting new feature: Extended Events Profiler (XE\u00a0Profiler)<\/strong>. This new feature is in a very early stage, but it seems to be a first step to replace SQL Profiler<\/strong>, which is already deprecated.<\/p>\n

Two different session templates appear under the new ‘XE Profiler’<\/em> item in object explorer: ‘Standard’<\/em> and ‘TSQL’<\/em>. They are not XE<\/strong> sessions by itself, they are templates. If you double-click one of them, a new live data window opens, capturing the server activity.<\/p>\n

\"XE<\/p>\n

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

\"XE<\/p>\n

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.<\/p>\n\n\n\n\n\n\n\n\n\n\n
Standard<\/strong><\/td>\nTSQL<\/strong><\/td>\n<\/tr>\n
Attention<\/td>\n\u00a0<\/td>\n<\/tr>\n
existing_connection<\/td>\nexisting_connection<\/td>\n<\/tr>\n
login<\/td>\nlogin<\/td>\n<\/tr>\n
logout<\/td>\nlogout<\/td>\n<\/tr>\n
rpc_completed<\/td>\nrpc_starting<\/td>\n<\/tr>\n
sql_batch_completed<\/td>\n\u00a0<\/td>\n<\/tr>\n
sql_batch_starting<\/td>\nsql_batch_starting<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

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.<\/p>\n

On this early stage, the final result of this feature is similar to the ‘Watch Live Data’<\/em> XE<\/strong> feature and a lot less powerful than SQL Profiler,<\/strong> due to the lack of customization. However, This feature seems to be the first stage for SQL Profiler<\/strong> replacement since it was set as deprecated and, due to that, it deserves our attention.<\/p>\n","protected":false},"excerpt":{"rendered":"

Starting in SSMS version 17.3, we have an interesting new feature: Extended Events Profiler (XE\u00a0Profiler). This new feature is in a very early stage, but it seems to be a first step to replace SQL Profiler, which is already deprecated. Two different session templates appear under the new ‘XE Profiler’ item in object explorer: ‘Standard’……<\/p>\n","protected":false},"author":50808,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143527],"tags":[5966],"coauthors":[6810],"class_list":["post-74634","post","type-post","status-publish","format-standard","hentry","category-database-administration-sql-server","tag-monitor"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/74634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/50808"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=74634"}],"version-history":[{"count":2,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/74634\/revisions"}],"predecessor-version":[{"id":74801,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/74634\/revisions\/74801"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=74634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=74634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=74634"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=74634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}