Usage Based Optimization in SSAS 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Yaniv Mor » Usage Based Optimization in SSAS 2005

Usage Based Optimization in SSAS 2005

Rate Topic

Display Mode

Topic Options

Author

Message

Yaniv Mor

Posted Saturday, May 13, 2006 11:49 AM

SSC 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

HANNES MAYER

Posted Tuesday, May 30, 2006 12:30 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 08, 2013 4:42 AM
Points: 2, Visits: 6

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

Yaniv Mor

Posted Thursday, May 31, 2007 5:36 PM

SSC 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

dhruvmpanchal

Posted Monday, May 17, 2010 6:41 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 02, 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 »

Permissions