Performance Optimization: Does it improve if OLAP service is on a remoted server? - 05-13-2004 , 01:20 PM
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
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.
Re: Performance Optimization: Does it improve if OLAP service is on a remoted server? - 05-13-2004 , 07:20 PM
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
Colombia - SQL Server MVP
" David N" <dq.ninh (AT) netiq (DOT) com> wrote