Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

We currently update our analysis services cube every 15 min. We want this closer to real time if possible.

We have our TFS Server and our SQL Server on the same machine. If we split these to use two machines, would the extra power of having two machines make it possible to lower the cube update without noticing a performance drop? I would like to take it to around 2 min (or less if possible).

What do you think? Would this work? Or am I asking too much?

share|improve this question

2 Answers 2

up vote 1 down vote accepted

Maybe.

The answer is impossible for anyone but you to say. Its completely dependent on the hardware involved and the load involved.

Buy big enough hardware (either two separate machines or one even bigger machine) and I'm sure you can do it.

share|improve this answer

You can also move analysis services to its own hardware for maximum power. If you look at the page you link, it says that dual-server means "two or more" servers. Topology is more flexible than ever before in tfs2010.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.