Connection performance

Post Reply
wang_chris
Posts: 101
Joined: Thu Jan 31, 2013 1:03 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Connection performance

Post by wang_chris »

We have a TM1 server set on a VMware machine.

I found the connection response from remote architect client to the server is quite slow, it costs me almost 2.5 minutes to get the server's response after my user name and password are enter.

But when I logon the VMware machine and then logon to TM1 server from local, the response is very quick.

What's the problem, and how can I optimize it?

Regards,
Chris
User avatar
gtonkin
MVP
Posts: 1200
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Connection performance

Post by gtonkin »

This could be a whole host of issues but would try the following to begin with:
Run a ping from a workstation to the virtual server and note the response times
Do the same from the server to the workstation
You can also run a pathping to double-check that the routing is not going around the world first.
If the responses are slow, networking may be the cause and IT may need to get involved to assist.
Note: ICMP traffic is often dropped if the destination is too busy or if admins have specifically blocked it.
Run these tests over a few hours to establish some kind of averages

If all seems normal here, could be anti-virus or resource allocation etc. etc.
tomok
MVP
Posts: 2832
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Connection performance

Post by tomok »

Did you try searching for this topic before posting? There would have to be thousands of posts about this very topic (maybe a little exaggeration). it's a well known fact that the fat clients (Architect and Perspectives) require a lot of bandwidth and very low latency to be viable remote connections. Citrix and/or remote desktop is the most popular solution.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Connection performance

Post by jim wood »

Have you done any research regarding TM1 and a WAN? If you doa search on here you'll find a lot of pointers. Pretty much the best options (at the moment) are TM1 web (or application server) and Cafe. I'd advise doing some research on these,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
Steve Rowe
Site Admin
Posts: 2417
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Connection performance

Post by Steve Rowe »

What is the performance like when you are actually using the system?

Population of the object tree can take some time on first log on, though over two minutes is a long time. I would expect you to have a very large number of objects in your instance (1000s). This includes all your views and subsets, public and private.

It might be helpful if you describe that state of your client, i.e. where is it in relation to your instance?

Cheers,
Technical Director
www.infocat.co.uk
Post Reply