AS2005 x64 vs x86 performance

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


.

Relevant Pages

  • Re: AS2005 x64 vs x86 performance
    ... 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... ... On the dual xeon maschine each time an XMLA is executed, ...
    (microsoft.public.sqlserver.olap)
  • Re: AS2005 x64 vs x86 performance
    ... My issues are related with XMLA command ... executed one of the execution units goes 100% for some seconds. ... I've used the management studio on the server via remote desktop. ... The disk sys on the xeon srv is a FC SAN where I have an array of 4 FC ...
    (microsoft.public.sqlserver.olap)
  • Re: AS2005 x64 vs x86 performance
    ... I've traced with profiler the XMLA sent to AS. ... I was alone on the server. ... Each execution made one execution unit 100%. ... The disk sys on the xeon srv is a FC SAN where I have an array of 4 FC ...
    (microsoft.public.sqlserver.olap)
  • Re: sbs on a Bi Xeon server
    ... We have happily run a dual Xeon for the last two years. ... We only have 2 Gb of RAM -- seems like plenty so far. ... Is it worth it to install SBS 2003 on a server equiped of 2 Xeon ...
    (microsoft.public.windows.server.sbs)
  • Re: Multi-Core CPUs & SolidWorks?
    ... Then why, in the may issues of Desktop Engineering, do dual Xeon ... systems blow everything away on the SPECapc Solidworks 2005 tests? ... It makes it look like this 'don't bother with dual processors' stuff ...
    (comp.cad.solidworks)
Loading