SQL Server Performance Forum – Threads Archive
Analysis Services 2005 Performance tuning helpI’m just wondering if someone could explain all the performance tuning techniques that could be used for Analysis Services 2005 that can be used in a cube to help speed up query execution. Things like creating aggregations, Improving Calculated members to contain more scoping or something along these lines. Thanks in Advance, Mike
Your question covers such a broad area. Remember this site is much more than just a forum <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /><br /><br /<a target="_blank" href=http://www.sql-server-performance.com/articles_performance.asp>http://www.sql-server-performance.com/articles_performance.asp</a><br /><br />
As mentioned, this is a huge subject and performance issues can be for a huge number of reasons. We are continue to work to make our performance faster, but we are approaching each area systematically. We came from a sql 2k world and are learning to take advantage of 2k5.
A couple of highlights of areas to look into (as a very high level start)
If you can convert some calculated members into base measures – this can improve performance – but you need to look at each calculated member individually to see if it can be a base measure and still aggrigate properly
Partitioning is another option that if done well can improve performance There is more of course, but its such a broad question that I wouldnt know how to give a specific answer.