asked on

Replication and SSAS on the same server

We are about setup a large warehouse enviornment(around 2T) with the datamart and the subscriber(Transactional replication from OLTP)
all on the same server. We have 2 dual core processor and 64G RAM on that server.Is this duable?Will I have any performance issues?

aelliso3

There is a lot more dependencies that are needed to answer that question. Some of the more important depends on how you place the data/log files, how much and how large of reporting will be done, number of concurrent users, how many tables/db's, etc.
I've used servers that were about this size under a reasonable minimal load and it did fine, but I've also used bigger with more heavy duty reporting that suffer pretty bad performance issues at given times of the day.

venk_r

ASKER

Thanks for the reply.
The replicated database would be around 1 Terabyte in size containing 1 year data.
The datamart will get build everyday during late night in a incremental way Which will eventually store 2 years of data at any point.
The cubes will be partitioned month wise and will be rebuilt accordingly every night.
Being said users will have access to the cubes round the clock.Repomes.Reporting might get heavier at times.
The disks for the data and log files will be placed on different discs(fibre channel).
We are looking at R710 Dell series with 144G Ram AND 8 core dual processors.
Any advice is appreciated.

Venkat

ASKER CERTIFIED SOLUTION

aelliso3

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

TAB8