SQL Server Performance

Analysis Services 2005 Performance tuning help

Discussion in 'SQL Server 2005 Analysis Services' started by johni, Feb 15, 2006.

  1. johni New Member

    I'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
  2. Chappy New Member

    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 />
  3. ChrisFretwell New Member

    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.

Share This Page