Analysis Services Performance Specs

Issam sent me a great link the other day about some Analysis Services nut. I spent time looking over the dude's site and see that many of the links were out of date. One link that got broken that particularly interested me was the performance links. Since some of them were broken but sparked my interest, I decided to find them myself. So far, I have spent the most time here and I was amazed at some of the information that I found and couldn't believe how easy some of the obvious solutions were. An example was that when there are multiple levels of a single dimension on a slice, AS will run each query seperately and cache it. This way there is no need to go back to the server when the user toggles through the levels. My next great find will be detailed documentation on caching algorithms for PTS.

Print | posted on Friday, September 24, 2004 10:06 AM