Slow Aggregations Designer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yash - 23 Oct 2004 12:25 GMT

Hi,
Any hints why the aggregation designer will be slow.
Many Thanks.

Signature

Regards,
Yash

Reply to this Message

Dave Wickert [MSFT] - 24 Oct 2004 02:12 GMT

Sure. Mostly because of high complexity forces the total possible aggregates
to exponentially grow. See the various techinques you can use to work with
high complexity discussed in the following two white papers.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ansvcspg.mspx

Signature

Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

> Hi,
> Any hints why the aggregation designer will be slow.
> Many Thanks.

Reply to this Message