1. if I have SQL server and AS on separate machines and I execute a MDX

query for a rolap cube, consume this query too many resources on the BD

server?


2. it really improves the performance of my server, if i separate it in

the 2 mentioned machines???


3. What percent of the load of a query takes the BD machine, (aprox)???



Thanks,
Cecilia

if most of the accesses are against the same content, then the AS cache will
help you.
using 2 servers always improve the performance by sharing the throughput.

but personally I prefer to invest "everything" in 1 server.
Specially in B.I. solutions and when the accesses are random. ("1 user can
do only 1 thing at a time; 2 servers = 1 idle while the second do the job
slowly")
You'll have a bigger hardware with a higher performance.

Also, take a look at SSAS 2005 and the proactive caching feature. the
performance can be really excellent.
the server will scan the source at a regular basis and update the cube cache
with the new content without creating ROLAP aggregation (a slow process)


"Hoody" <Hoody.cu (AT) gmail (DOT) com> wrote