Page 1 of 1

Need suggestion on TM1 server

Posted: Mon Nov 03, 2008 9:37 am
by wpreech
Hi,
I'm planning for setting up a TM1 environment for our department to do forecast (using Perspective Excel). The info I have is there are 20+ entities, about 100 of cubes, and 130 of concurrent users from many countries (about 100ms to the server). Since TM1 doesn't response well on the long distance, so we also plan for a Terminal Services server for all users. We're looking to go with 2 x quadcore 2.5 GHZ CPU and 32GB of RAM for TM1 (Windows 2003 64-bit), and 1 x quadcore 2.5 GHz with 16GB RAM for TS. Any comment please?

Re: Need suggestion on TM1 server

Posted: Mon Nov 03, 2008 9:53 am
by jim wood
Sounds like a good plan. You may want to also consider creating summary cubes for each country / region. The smaller cubes hould perform better and recue network traffic,

Jim.

Re: Need suggestion on TM1 server

Posted: Mon Nov 03, 2008 11:38 am
by Martin Erlmoser
you can give your TS Server a little bit more RAM (normaly i calculate with 100mb/user but for 130 tm1users (controller always try to open as many excelsheets as possible ;) ) i would calculate with 150mb)

Re: Need suggestion on TM1 server

Posted: Mon Nov 03, 2008 11:44 am
by mattgoff
Strong agree on the terminal server-- TM1 barely works for us across the US, much less internationally (and replication is problematic, at best). We went with replicating servers which I do not recommend-- replication is problematic at best (and adds a lot of administrative complexity). As far as TM1 server specs, it's hard to say as it really depends on your model: density, rules, etc. In my experience processors (qty, speed) are nearly irrelevant except during startup but having heaps of RAM is a requirement. My advice is to just make sure you pick a server with room to grow.

Matt