Post reply

Usage Based Optimization in SSAS 2005

  • May 13, 2006 at 11:49 am

    #168292

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

  • May 30, 2006 at 12:30 pm

    #640750

    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.

  • May 31, 2007 at 5:36 pm

    #710162

    Hi Hannes,

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

    Yaniv

  • May 17, 2010 at 6:41 pm

    #1168543

    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 3 (of 3 total)

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