mibuso.com

Microsoft Business Solutions online community
It is currently Wed Nov 26, 2014 1:13 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Slow response time through TSE
PostPosted: Wed Nov 11, 2009 12:28 pm 
Offline

Joined: Thu Feb 19, 2004 5:21 pm
Posts: 20
Location: Paris
Country: France (fr)
Hi,

We have the following installation :
4 companies, 2 databases (2x2 companies)

Each SQL DB is hosted on a different SQL Server.

SQL1 has 16 gb RAM
SQL2 has 4 gb RAM
Both SQL Servers runs :
Windows Server 2003 R2 SP2
Microsoft SQL Enterprise Manager V8.0
NAV 3.70

The Network cards are the same, with the same driver.

The users are balanced on 5 TSE servers.

The Database hosted on SQL1 has good response times directly on the server. It becomes very slow thgrough TSE. The SQL2 hosted DB has quite the sames response times on the SQL console and through the TSE.

We tried to backup and restore the DB from SQL1 to SQL2 and the response times were very good through TSE, so this doesn't come from the DB.

Do you have any idea of what could help ?

_________________
Business Analyst
Incadea (Vertical solution for the automotive market based on Nav 2.60)
French speaking European/African/Indian Ocean countries.


Top
 Profile  
 
 Post subject: Re: Slow response time through TSE
PostPosted: Sat Nov 14, 2009 3:05 pm 
Offline

Joined: Sat Oct 17, 2009 10:37 am
Posts: 50
Hi Aure69

What sort of network infrastructure do you have between the terminal servers and the slow SQL server? A network hub, faulty network switch, faulty network card or congested network cable could be responsible for the problem. Ideally the link would be gigabit switched.


Top
 Profile E-mail  
 
 Post subject: Re: Slow response time through TSE
PostPosted: Sat Nov 14, 2009 4:45 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Jul 31, 2003 11:00 am
Posts: 640
Location: Nürnberg
Country: Germany (de)
How are the TS size? According to the MS recommendations you should ...

... run no more than 10 (to max. 15) users per CPU (for example 20 Users on one Dual Core CPU)
... have 64 MB RAM per User
... have 500 MB Disk-Space per User (SAS/uSCSI, 15k rpm)
... have Gigabit Network

This just fulfills the requirements for NAV only; the requirements of other applications have to be added on top of this.

_________________
Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: