THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Erin Welker

SQL Server and Business Intelligence

Analysis Services Performance Whitepaper - a little light reading

The SQL Server 2008 version of the Analysis Services Performance Guide was published last month.  I've yet to read it - it's 80 pages (which is actually less than its 2005 predecessor).  I'm sure there's some overlap with that one but, since it has different authors, the information is presented differently.  And, of course, it has been updated for SQL Server 2008.  

Published Monday, December 01, 2008 10:27 PM by ErinW

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

James Luetkehoelter said:

This is an excellent "popeller-head" (I'm not saying it like is a bad thing) guide to Analysis Services. However, what it lacks (and maybe this isn't the place for it) are REAL situations. When I look at somethink like Marco Russo's Dimensional Modeling ebook/book, he goes through real examples of how you would use the power of SSAS for a business problem. One example - a many-to-many dimensional relationship. He approaches it with of a bill of materials problem, which every manufacturing company has.

Another thing that isn't touch on is tangential tuning (again, probably not the write place for, but important I think nonetheless). The idea of where do you want your latency? If you can do certain calculations in your ETL, do them there. If you can do them in the consuming application, perhaps do them there. All to often I see MDX as the bandaid for to represent in Analysis Services a specific business problem. It's great, don't get me wrong. But we need more of the real-world out there MS. Please.

December 2, 2008 7:49 PM

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement