THE SQL Server Blog Spot on the Web

Welcome to - 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 1, 2008 10:27 PM by ErinW



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
New Comments to this post are disabled
Privacy Statement