{"id":475,"date":"2012-07-12T19:49:00","date_gmt":"2012-07-12T19:49:00","guid":{"rendered":"\/blogs\/bobb\/post\/Extended-Events-in-Windows-Azure-SQL-Database.aspx"},"modified":"2013-01-03T23:59:20","modified_gmt":"2013-01-04T07:59:20","slug":"extended-events-in-windows-azure-sql-database","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/","title":{"rendered":"Extended Events in Windows Azure SQL Database"},"content":{"rendered":"<p>\nContinued from the previous post, &quot;<a href=\"http:\/\/3.209.169.194\/blogs\/bobb\/some-newupcoming-windows-azure-sql-database-dmvs-and-diagnostics\/\">Some new\/upcoming Windows Azure SQL Database DMVs and diagnostics<\/a>&quot;&#8230; Read that one to find out who Vinod and Michal are.\n<\/p>\n<p>\nSo, before you all run out and try it, this isn&#39;t working yet. But, like the WASD event log view, the pieces seem to be in place. So, standard disclaimer applies. I only saw it working in Vinod and Michal&#39;s demo. The stuff I&#39;m looking at may bear no resemblance to the final product. On the other hand, it may&#8230;\n<\/p>\n<p>\nSo, I went looking in&nbsp;WASD today. Some of the extended event views exist in every database today. This jibes with the demo that showed an XEvent node in SSMS Object Explorer in the Database\/Programmability folder. As opposed to XEvents sessions, etc in SQL Server which live in master, these appear to live in each database. Which only makes sense if you know how WASD works&#8230;\n<\/p>\n<p>\nObviously there is no SSMS node in SSMS today. But for those of us who like XEvents in SQL Server 2008, sans GUI, that really doesn&#39;t present a problem.\n<\/p>\n<p>\nThey showed four pre-defined XEvent sessions, and said that initially there would only be predefined sessions. No user-defined sessions. The names they showed matched the output from &quot;select * from sys.event_sessions&quot; and are:\n<\/p>\n<p>\nazure_xe_activity_tracking<br \/>\nazure_xe_query_batch<br \/>\nazure_xe_query_detail<br \/>\nazure_xe_query_waits\n<\/p>\n<p>\nYou can get metadata and &quot;current&quot; data by using views that are similarly named to the views in SQL Server. SSMS object explorer for WASD shows the following:\n<\/p>\n<p>\nsys.event_session_actions<br \/>\nsys.event_session_events<br \/>\nsys.event_session_fields<br \/>\nsys.event_session_targets<br \/>\nsys.event_sessions\n<\/p>\n<p>\nsys.dm_xe_database_session_event_actions<br \/>\nsys.dm_xe_database_session_events<br \/>\nsys.dm_xe_database_session_object_columns<br \/>\nsys.dm_xe_database_session_targets<br \/>\nsys.dm_xe_database_sessions\n<\/p>\n<p>\nSome of these views are more &quot;filled in&quot; than others. For example, the views related the XEvent targets are currently empty. And there are no targets for any of the predefined event session.&nbsp; Note the use of the naming convention &quot;dm_xe_database&#8230;&quot; for the views instead of &quot;dm_xe_server&#8230;&quot;. Makes sense.\n<\/p>\n<p>\nSo, gui or no gui, target or no target, I just had to try this. Had my &quot;stop&quot; and &quot;harvest&quot; scripts available in case it did start, but&#8230;\n<\/p>\n<p>\nalter event session azure_xe_query_waits on server state=start;\n<\/p>\n<p>\nProduces: &quot;session does not exist or you do not have permission&quot;\n<\/p>\n<p>\nHmmm&#8230; how about:\n<\/p>\n<p>\nalter event session azure_xe_query_waits on database state=start;\n<\/p>\n<p>\nProduces: &quot;Failed to start event session &#39;azure_xe_query_waits&#39; because doing so will exceed the maximum number allowed for this database.&quot;\n<\/p>\n<p>\nSounds like that could be the ticket. In future. So, until then, folks diagnosing WASD issues wait for the announcement for this, and the event log views, with baited breath. When I asked some SQL Azure folks about the lack of announcements about the &quot;intermediate&quot; versions of WASD (i.e. there was no formal announcement on the Azure blog about the new DMVs), the response was &quot;we&#39;d like to make small version changes to WASD a non-event, and only announce large changes&quot;. This will be a big&#8230;eh&#8230; event. THANKS Vinod and Michal.\n<\/p>\n<p>\n@bobbeauch<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Continued from the previous post, &quot;Some new\/upcoming Windows Azure SQL Database DMVs and diagnostics&quot;&#8230; Read that one to find out who Vinod and Michal are. So, before you all run out and try it, this isn&#39;t working yet. But, like the WASD event log view, the pieces seem to be in place. So, standard disclaimer [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,15],"tags":[],"class_list":["post-475","post","type-post","status-publish","format-standard","hentry","category-sql-azure-database","category-extended-events"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Extended Events in Windows Azure SQL Database - Bob Beauchemin<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extended Events in Windows Azure SQL Database - Bob Beauchemin\" \/>\n<meta property=\"og:description\" content=\"Continued from the previous post, &quot;Some new\/upcoming Windows Azure SQL Database DMVs and diagnostics&quot;&#8230; Read that one to find out who Vinod and Michal are. So, before you all run out and try it, this isn&#039;t working yet. But, like the WASD event log view, the pieces seem to be in place. So, standard disclaimer [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Bob Beauchemin\" \/>\n<meta property=\"article:published_time\" content=\"2012-07-12T19:49:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-01-04T07:59:20+00:00\" \/>\n<meta name=\"author\" content=\"Bob Beauchemin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bob Beauchemin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/\",\"name\":\"Extended Events in Windows Azure SQL Database - Bob Beauchemin\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\"},\"datePublished\":\"2012-07-12T19:49:00+00:00\",\"dateModified\":\"2013-01-04T07:59:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure SQL Database\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/sql-azure-database\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Extended Events in Windows Azure SQL Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\",\"name\":\"Bob Beauchemin\",\"description\":\"SQL Server Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\",\"name\":\"Bob Beauchemin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"caption\":\"Bob Beauchemin\"},\"sameAs\":[\"http:\/www.sqlskills.com\/blogs\/bobb\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Extended Events in Windows Azure SQL Database - Bob Beauchemin","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/","og_locale":"en_US","og_type":"article","og_title":"Extended Events in Windows Azure SQL Database - Bob Beauchemin","og_description":"Continued from the previous post, &quot;Some new\/upcoming Windows Azure SQL Database DMVs and diagnostics&quot;&#8230; Read that one to find out who Vinod and Michal are. So, before you all run out and try it, this isn&#39;t working yet. But, like the WASD event log view, the pieces seem to be in place. So, standard disclaimer [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/","og_site_name":"Bob Beauchemin","article_published_time":"2012-07-12T19:49:00+00:00","article_modified_time":"2013-01-04T07:59:20+00:00","author":"Bob Beauchemin","twitter_misc":{"Written by":"Bob Beauchemin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/","name":"Extended Events in Windows Azure SQL Database - Bob Beauchemin","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website"},"datePublished":"2012-07-12T19:49:00+00:00","dateModified":"2013-01-04T07:59:20+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/extended-events-in-windows-azure-sql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/"},{"@type":"ListItem","position":2,"name":"Azure SQL Database","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/sql-azure-database\/"},{"@type":"ListItem","position":3,"name":"Extended Events in Windows Azure SQL Database"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/","name":"Bob Beauchemin","description":"SQL Server Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e","name":"Bob Beauchemin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","caption":"Bob Beauchemin"},"sameAs":["http:\/www.sqlskills.com\/blogs\/bobb\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/comments?post=475"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/475\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/media?parent=475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/categories?post=475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/tags?post=475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}