Usage Based Optimization in SSAS 2005

  • Yaniv Mor

    SSC Eights!

    Points: 936

    Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/ymor/usagebasedoptimizationinssas2005.asp

  • HANNES MAYER

    SSC Journeyman

    Points: 92

    Do anyone of you know a tool like in SSAS2000 to manually add or view the aggregations designed by thw wizzard (like the partition aggregation utility in SSAS2000)?

    to manually modify and tune according to special conditions and size requierements.

  • Yaniv Mor

    SSC Eights!

    Points: 936

    Hi Hannes,

    You can find such a tool with SP2 for SSAS 2005.

    Yaniv

  • dhruvmpanchal

    SSC Journeyman

    Points: 75

    I know how to use wizard for usage based optimization. Does anyone know if it can done through SSIS script task or C#/.net programming object. the reason is that I cant start wizard every time i want to optimize aggregations. we have 50 clients and if I do manually for each client it will take lot of time. instead if i can schedule it through ssis task or code something it will be helpful.

    let me know if someone can help me.

    thanks.

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

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