Hi All,

If I have a warehouse database on a SQL server on NT machine A, and a OLAP
service/database on a remoted NT machine B, do I get a better performance
(or worse)?

While the idea of having two dedicated servers, one for OLAP, one for SQL,
seems to be a good idea at first glance, I am thinking of data has to be
tranfered remotedly, which may cause negative affect on the performance.

Can someone shed a light?

Thanks in advance.

David.

Basicaly it depens on 2 factors:

1. The storage model u r using (MOLAP< ROLAP< HOLAP) (When molap, u will
neer get into the star model, so no problem with users querying the cube)

2. If your users get really often to the detail data

Best perf scenario : MOLAP no issue if just in one server (If a medium or
bigger implementation, better put it on different machines, because u will
have more granular administration on disasters)

If u need some extra clarification, let me know

--
ALEJANDRO LEGUIZAMO
Colombia - SQL Server MVP


" David N" <dq.ninh (AT) netiq (DOT) com> wrote