Greetings,

I'm in condition, where we don't have powerful hardware, and yet
we need to process loads of data using Cubes.

My question would be, which of these is most loaded when desigining
and processing cubes (post design doesn't matter, since they get
moved to powerful hardware):

Workstation
SQL server machine
Analysis services macine

Which of these gets biggest load and should be improved most?

Thank you.

QQ

the Analysis Service Performance guide has a good section on improving
processing performance as per link below

http://www.microsoft.com/technet/pro.../ansvcspg.mspx

cheers,
Andy


"QQ" <qq-spam (AT) mail (DOT) lt> wrote

Yes, but it only talks about AS machine - and I'm not sure if AS
machine is the bottleneck here. Datasource is located on a different
machine, running SQL Server.

"Andy Ball" <andy.ball (AT) remove4spam_greenfell (DOT) com> wrote in
news:eBkdwuMSEHA.1048 (AT) tk2msftngp13 (DOT) phx.gbl: