HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.olap » Re: Aggregation Designer is not increasing Performance
Topic: Re: Aggregation Designer is not increasing Performance
Well, good for you then - but, according to this document, Aggregation
Usage should only be set to "Full" in special cases:
http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7
151b2011c/SSAS2005PerfGuide.doc
>>
Analysis Services 2005 Performance Guide
...
• Change the value of the Aggregation Usage property from Default to
Full in the unusual case that it is used in virtually every query you
want to optimize. This is a very rare case and should only be used for
attributes that have a relatively small number of members.
...
>>
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.developersdex.com ***
Replies below ↓