Hi all
Is there a way to control the amount of CPU Analysis Services consumes?
During aggregations calculation the server is totally blocked after nearly
100%
of it's cpu is being consumed by AS.
I am using w2k server witn 2gb memory with sql and Analysis servers standart
edition.
Thanks alot
Rea

Try using "Lazy Aggregation Mode".

James

"Rea Peleg" wrote:

Unfortunately, No. There is no CPU throttling. It uses what it uses :-)
--
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.

"Rea Peleg" <rea_p (AT) afek (DOT) co.il> wrote