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?