Post reply

Perfomance Tuning

  • July 7, 2010 at 5:49 am

    #145852

    Hi,

    I like to know what are all the best practise to optimise the cube. what are all steps to be taken care .

    Thanks in Advance!

    Sabarinathan.C

  • July 7, 2010 at 6:31 am

    #1189566

    Hi,

    Please follow the url http://technet.microsoft.com/en-us/library/cc966399.aspx

    Hope this helps.

    Raunak J

  • July 8, 2010 at 3:25 am

    #1190085

    Hi SSC,

    Thanks for quick response. but that material looks very vast but i need Crisp and short notes kind of information.

    sorry for asking such a silly kind of questions. but i will continue reading the link .

    please provide me short and crisp answer or some points to follow to optimise the cube.

    Thanks and Regards,

    Sabarinathan.C

  • July 8, 2010 at 8:09 am

    #1190260

    Sabarinathan,

    (Assuming you want to optimize the querying experience) In short, you need to ensure you have:

    - attribute relationships set up correctly in your dimensions

    - partitioning where appropriate

    - aggregations on partitions where appropriate

    I know this may sound harsh but optimization of cubes is not exactly something that you can boil down into 3 bullet points - unless of course, you actually already knew the details behind each point which would then mean you probably wouldn't ask the question.

    Your best bet is to read through the performance guide and then relate it's recommendations to the problems you're experiencing.

    HTH,

    Steve.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply