{"id":29,"date":"2007-08-09T21:42:43","date_gmt":"2007-08-10T02:42:43","guid":{"rendered":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/29_ssas-2008-katmai-info-from-august-9th-webcast"},"modified":"2008-03-17T21:05:38","modified_gmt":"2008-03-18T02:05:38","slug":"ssas-2008-katmai-info-from-august-9th-webcast","status":"publish","type":"post","link":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/29_ssas-2008-katmai-info-from-august-9th-webcast","title":{"rendered":"SSAS 2008 Katmai &#8211; info from August 9th webcast"},"content":{"rendered":"<p>In my\u00a0last <a target=\"_blank\" href=\"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/28_ssas-2008-katmai-upcoming-changes-in-the-next-ctp\">post<\/a> I listed changes that are expected in SSAS 2008 next CTP 4. But it looks like none of the changes made into July CTP. They probably were postponed last minute. Even\u00a0new Microsoft\u00a0documentation\u00a0(read Chris Web\u00a0 <a target=\"_blank\" href=\"http:\/\/cwebbbi.spaces.live.com\/blog\/cns!7B84B0F2C239489A!1314.entry\">blog<\/a>)\u00a0lists some of the features\u00a0as present. For example block computation is listed in documentation, but just today in webcast I saw block computation example where\u00a0in CTP4 it took query to execute 1min, and in new SSAS build the same query come back in a few seconds. So I hope that all changes listed in my previous post will be in the next CTP5, that is targeted for September 18th release (during PASS conference).<\/p>\n<p>Today there was\u00a0another good webcast presentation &#8220;<a target=\"_blank\" href=\"http:\/\/www.microsoft.com\/events\/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&amp;Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032345989%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Value%3d%22en%22%2f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e%7esParams%5e%7e%2fsParams%5e%7e%2fCMTYDataSvcParams%5e\" title=\"http:\/\/www.ssas-info.com\/VidasMatelisBlog\">The value of Business Intelligence with SQL Server 2008<\/a>&#8221; by Julie Strauss (Product Manager) &amp; Donald Farmer (Principal Program Manager). From this presentation I got more info on 2 new enhancements (not listed in my previous posts) that we\u00a0should\u00a0expect in the next CTP.<\/p>\n<p><!--more-->First of all, we should expect enhancements to aggregation designer. Algorithm that builds aggregations will be improved, there will be support for manual edit\/create\/delete of aggregations and we should be able to see what aggregates were designed. Also aggregation designer will have built-in validations for optimal design assistance. In my opinion this is very welcome change as I absolutely would love to have much better control on what aggregations are build.<\/p>\n<p>And the\u00a0another new enhancement will be DMV (<strike>Data<\/strike> Dynamic Management Views) that we will be able to use to access information about Analysis Services.\u00a0As I understood, there will be something like &#8220;Default Resource cube&#8221;, that DMV will query and come back with useful information. During webcast presenter demonstrated 2 views:<\/p>\n<ul>\n<li>$system.discover_connections<\/li>\n<li>$system.discover_sessions<\/li>\n<\/ul>\n<p>To access DMV, you simply write SELECT statement:<\/p>\n<blockquote><p>SELECT * FROM $system.discover_connections<\/p><\/blockquote>\n<p>Below are example of queries that list just some (!) of the columns available in these DMVs:<\/p>\n<blockquote><p>SELECT<br \/>\nconnection_id<br \/>\n, connection_user_name<br \/>\n, connection_host_application<br \/>\n, connection_start_time<br \/>\nFROM $system.discover_connections<\/p>\n<p>SELECT<br \/>\nsession_id<br \/>\n, session_spid<br \/>\n, session_user_name<br \/>\n, session_last_command<br \/>\n, session_start_time<br \/>\n, session_cpu_time_ms<br \/>\n, session_reads<br \/>\n, session_writes<br \/>\n, session_status<br \/>\n, session_current_database<br \/>\n, session_used_memory<br \/>\n, session_properties<br \/>\n, session_start_time<br \/>\n, session_elapsed_time_ms<br \/>\n, session_last_command_start_time<br \/>\n, session_last_command_end_time<br \/>\nFROM $system.discover_sessions<\/p><\/blockquote>\n<p>As you can see there is a lot of info in session records. For example it is quite\u00a0easy to get session ID and resources used by the session.<\/p>\n<p>To list SSAS sessions that are currently active you can filter session DMV using WHERE session_status = 1:<\/p>\n<p>To\u00a0kill session, get session id from DMV and execute XMLA:<\/p>\n<blockquote><p>&lt;Cancel xmlns=&#8221;<a rel=\"nofollow\" target=\"_blank\" href=\"http:\/\/schemas.microsoft.com\/analysisservices\/2003\/engine\">http:\/\/schemas.microsoft.com\/analysisservices\/2003\/engine<\/a>&#8220;&gt;<br \/>\n\u00a0 &lt;SPID&gt;###HereGoesSessionID###&lt;\/SPID&gt;<br \/>\n&lt;\/Cancel&gt;<\/p><\/blockquote>\n<p>Note: In 2008 cancel is reliable and should kill session instantly.<\/p>\n<p>To get a list of columns available in DMV you can\u00a0execute following queries:\u00a0<\/p>\n<blockquote><p>select * FROM $system.DBSCHEMA_columns WHERE table_name = &#8216;discover_sessions&#8217;<br \/>\nselect * FROM $system.DBSCHEMA_columns WHERE table_name = &#8216;discover_connections&#8217;<\/p><\/blockquote>\n<p>I am sure DMVs will be very big help in finding runaway queries and monitoring SSAS.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In my\u00a0last post I listed changes that are expected in SSAS 2008 next CTP 4. But it looks like none of the changes made into July CTP. They probably were postponed last minute. Even\u00a0new Microsoft\u00a0documentation\u00a0(read Chris Web\u00a0 blog)\u00a0lists some of the features\u00a0as present. For example block computation is listed in documentation, but just today in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,6],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/29"}],"collection":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/comments?post=29"}],"version-history":[{"count":0,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/29\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/media?parent=29"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/categories?post=29"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/tags?post=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}