Re: AS2005 x64 vs x86 performance

Hmm the GHz > Multiprocessor is not true ..

I've installed the olap database backup on a 2.13GHz, 2G RAM notebook and
the save agregation is still running twice as fast as the xeon server...

the xeon is x64 and the notebook and pc are x86...

Is something screwed up with the x64 version of AS???.. The SQL is running
like a charm on the same maschine.


"Jéjé" <willgart_A_@xxxxxxxxxxxxxx> wrote in message
news:eSz1rT$qGHA.4508@xxxxxxxxxxxxxxxxxxxxxxx
a standard MDX query against a non partitionned cube use only 1 thread so 1
CPU.
if you have partitions or a query which ask for measures from different
measure group you should see more then 1 CPU to works at the same time.

its true, sometimes a single PC is better then a Xeon server, but not when
you start to have multiple users or processes.

sorry to say this, but I also found SATA drives far better then SCSI
drives!!!
SCSI drives are good only when the controller has enough cache.
so take a look at your disks and test them.

"Radu Colceriu" <radu_colceriu@xxxxxxxxxxx> wrote in message
news:%23IxPW18qGHA.1852@xxxxxxxxxxxxxxxxxxxxxxx
HI..

I have an setup like
- 2xXeon 2.8 dual-core 8GRAM, Win2003 x64, SQL 2005 EE x64
- PC P4 3.2G 2 G RAM. Win 2003 x86 SQL 2005 EE x86

I don't know why but on the PC the AS is working *much* faster than on
the Xeon system.

Especially designig agregation/creating roles/ creating partitions a.s.o.
So it seems that the same XMLA is executed almost twice as fast on the PC
than on the dual xeon.

On the dual xeon maschine each time an XMLA is executed, one of the 8
(2xdualcore + hyperthreading) "cores" is 100% but all other are doing
nothing.

On the same maschines SQL is running much faster on the Xeon maschine
than on the PC.


Any ideeas?

Thanks,
Radu





.

Loading