Hi!

Is there a way to make "storage design" to use all available processors?

Thanks.

No. If you need to run it for more than 15-30 minutes, you're probably
designing way too many aggregates. See some recent posts on this topic.

-Sean

Sean Boon
Microsoft Office BI


"Roust_m" <roustam (AT) hotbox (DOT) ru> wrote

Microsoft states that I can have up to 65535 aggregations per partition.
It takes more the 30 minutes to design storage with 1500 aggregations
and 8% performance gain. Am I having to many aggregations? If yes, why
it is so far from the limit?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

The Analysis Services Performance Guide has an extensive section on this
topic.
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) 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.

"Roustam Akhmetov" <roustam (AT) hotbox (DOT) ru> wrote