SSAS Maestro | Vidas Matelis Analysis Services Blog

About me

I work as SQL Server DBA / Developer and BI Consultant in Toronto, Canada. Canada Flag

Vidas Matelis picture

Links

Strategy Companion

Categories

a:4:{s:4:"body";s:5876:"

An Introduction to SSAS Performance and SQL Sentry Performance Advisor for Analysis Services

Written by Steve Wright

Tuesday, 21 February 2012 02:38

Over the past couple years, since SQL Sentry introduced Performance Advisor for Analysis Services, I’ve heard many people say they see SSAS as a “black box” on their servers with no real visibility into troubleshooting performance issues. Performance Advisor (PA) lifts the shroud from Analysis Services, but for some it may not be obvious how to interpret all the information gained from this new visibility.

There are many resources out there that cover OLAP architecture and MDX, but much less in the way of an explanation to all the various metrics that are available and how they correlate with each other. In response, I developed a presentation I’ve given several times now at SQL Saturdays that I believe serves to “bridge the gap” for DBA’s that may be new to SSAS, or possibly even developers who lack a dedicated administrator and need to be able to tell where the bottleneck might be on their SSAS server. I was also privileged to be invited to an interview on RunAs Radio where I spent some time discussing this with Richard Campbell and Greg Hughes.

Read more - Part 1...

Read more - Part 2...

Read more - Part 3...

Read more - Part 4...

Tags: performance, tool

";s:4:"head";a:10:{s:5:"title";s:92:"An Introduction to SSAS Performance and SQL Sentry Performance Advisor for Analysis Services";s:11:"description";s:0:"";s:4:"link";s:0:"";s:8:"metaTags";a:2:{s:10:"http-equiv";a:1:{s:12:"content-type";s:24:"text/html; charset=utf-8";}s:8:"standard";a:5:{s:16:"meta_description";s:162:"Over the past couple years, since SQL Sentry introduced Performance Advisor for Analysis Services, I’ve heard many people say they see SSAS as a “black box”";s:13:"meta_keywords";s:16:"performance,tool";s:6:"robots";s:13:"index, follow";s:6:"author";s:8:"webadmin";s:5:"title";s:92:"An Introduction to SSAS Performance and SQL Sentry Performance Advisor for Analysis Services";}}s:5:"links";a:0:{}s:11:"styleSheets";a:1:{s:69:"http://www.ssas-info.com/components/com_yvcomment/assets/style001.css";a:3:{s:4:"mime";s:8:"text/css";s:5:"media";N;s:7:"attribs";a:0:{}}}s:5:"style";a:0:{}s:7:"scripts";a:2:{s:28:"/media/system/js/mootools.js";s:15:"text/javascript";s:27:"/media/system/js/caption.js";s:15:"text/javascript";}s:6:"script";a:0:{}s:6:"custom";a:0:{}}s:7:"pathway";a:3:{i:0;O:8:"stdClass":2:{s:4:"name";s:13:"SSAS Articles";s:4:"link";s:20:"index.php?Itemid=154";}i:1;O:8:"stdClass":2:{s:4:"name";s:18:"Performance Tuning";s:4:"link";s:48:"index.php?view=category&id=61:performance-tuning";}i:2;O:8:"stdClass":2:{s:4:"name";s:92:"An Introduction to SSAS Performance and SQL Sentry Performance Advisor for Analysis Services";s:4:"link";s:0:"";}}s:6:"module";a:0:{}}till don’t know if I passed all of the necessary requirements to become a SSAS Maestro, and it will take a few more weeks or even months till the lab, exam and case study results will be available. There is a very good chance that I have not achieved the SSAS Maestro requirements, as this course and the tests were very difficult. However, I still want to share my experience, as I strongly believe that this was by far the best training on SSAS that I have ever participated in. Read the rest of this entry »

Posted in SSAS, SSAS Maestro | 13 Comments »

Pyramid Analytics

SSAS White Paper list

January 26th, 2011 by Vidas Matelis

In a few weeks I am planning to go to Redmond for “SSAS Maestro” training. I am very excited that I was accepted for this training and I want to prepare for it as much as I can. As I was going through available SSAS papers, I realized that quick list of SSAS white papers could be useful for other SSAS developers, so I am posting it here:

Posted in SSAS, SSAS Maestro | 10 Comments »

blog stats