Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Usage Based Optimization in SSAS 2005 Expand / Collapse
Author
Message
Posted Saturday, May 13, 2006 11:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 12, 2012 1:38 AM
Points: 284, Visits: 493
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/ymor/usagebasedoptimizationinssas2005.asp


Post #279838
Posted Tuesday, May 30, 2006 12:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 2, Visits: 9
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.
Post #283668
Posted Thursday, May 31, 2007 5:36 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 12, 2012 1:38 AM
Points: 284, Visits: 493

Hi Hannes,

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

Yaniv




Post #370474
Posted Monday, May 17, 2010 6:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 2, 2011 11:40 AM
Points: 1, Visits: 50
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.
Post #923230
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse