mibuso.com

Microsoft Business Solutions online community
It is currently Fri Apr 25, 2014 4:53 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: RDP vs Client Performance NAV2009R2 with SQL
PostPosted: Mon Apr 23, 2012 11:14 am 
Offline

Joined: Thu Jul 29, 2004 3:28 pm
Posts: 12
Location: PTA
Country: South Africa (za)
Hi All,
I am by no means an expert in performance on NAV and SQL but I have been working with NAV long enough to have a “feel” for how it should perform.
We are encountering a very strange situation and I was wondering if someone can shed some light on this or have some experience in this.

When using Remote Desktop to the Server and performing 3 different tasks these are the speed results:
Action 1: 2 Seconds.
Action 2: 6 Seconds.
Action 3: 4 Seconds.

However, Connecting to the server via the client on the local machine and performing the same 3 actions, these are the results:
Action 1: 12 seconds.
Action 2: 92 seconds.
Action 3: 18 seconds.

It makes no difference selecting DEFAULT, TCP/IP, or Named Pipes from the client logon screen.
Network performance testing shows no issues and copying a 1 Gig file to the server from the client take as long as expected.
Any Ideas why this might be happening?

Some STATS:
Running NAV 2009 R2 Classic client (No 3tier)
Server is Windows 2008 latest service pack
SQL is SQL server 2008 (Latest service pack)
1Gigabit network

Looking forward to any ideas or suggestions.
Regards,
Bert

_________________
Bert


Top
 Profile  
 
 Post subject: Re: RDP vs Client Performance NAV2009R2 with SQL
PostPosted: Mon Apr 23, 2012 11:34 am 
Offline

Joined: Mon Jul 28, 2008 2:37 pm
Posts: 674
Location: AT
Country: Austria (at)
Your description only makes sense when the terminal server is on the same server as SQL server and when your actions (especially the 2nd one) include large amounts of data. Otherwise it makes no sense at all.


Top
 Profile  
 
 Post subject: Re: RDP vs Client Performance NAV2009R2 with SQL
PostPosted: Mon Apr 23, 2012 12:22 pm 
Offline

Joined: Mon Mar 12, 2007 3:07 pm
Posts: 347
Location: Hamburg
Country: Germany (de)
Check that NAV Client Build No. on Server and Client are identical. Then also check the object cache setting in both scenarios.

_________________
Frank Dickschat
FD Consulting


Top
 Profile E-mail WWW  
 
 Post subject: Re: RDP vs Client Performance NAV2009R2 with SQL
PostPosted: Mon Apr 23, 2012 2:18 pm 
Offline

Joined: Tue Jun 21, 2011 1:39 pm
Posts: 523
Country: Netherlands (nl)
When using Remote Desktop to the Server and performing 3 different tasks these are the speed results:
So you are running RDP on a PC and connecting to the server?

However, Connecting to the server via the client on the local machine and performing the same 3 actions, these are the results:
This is not clear to me. Are you using the local console on the server?


Top
 Profile E-mail  
 
 Post subject: Re: RDP vs Client Performance NAV2009R2 with SQL
PostPosted: Mon Apr 23, 2012 3:36 pm 
Offline

Joined: Thu Jul 29, 2004 3:28 pm
Posts: 12
Location: PTA
Country: South Africa (za)
Thx for all the responses...

OK, so by RDP I mean. From the clients computer, open up a remote desktop session to the Server running the NAV SQL Server. Then from that Desktop, start the client (Classic client with SQL server) and access database as per normal.

The Other scenario is the normal connection you would normally do... i.e. From the clients machine, open the NAV Classic client with SQL Server. Connect to the server and execute the actions.

So yes, I know with the Remote Desktop, I am using the Server resources for the client actions where as with the normal connection I am using the Client machine resources (For buffers etc..)

Action 2 is inserting 100 records...

The thing is, I don't understand why it is so much slower via the client machine than via a client on the server when remote desktop to the server.) The difference is just to big for 100 insertions.

Regards,

_________________
Bert


Top
 Profile  
 
 Post subject: Re: RDP vs Client Performance NAV2009R2 with SQL
PostPosted: Mon Apr 23, 2012 4:16 pm 
Offline

Joined: Mon Jul 28, 2008 2:37 pm
Posts: 674
Location: AT
Country: Austria (at)
bertoos wrote:
Action 2 is inserting 100 records...
The thing is, I don't understand why it is so much slower via the client machine than via a client on the server when remote desktop to the server.) The difference is just to big for 100 insertions
Yes and no. It depends: How are the records inserted (dataport, xmlport, CAL code,...)? How many fields are included? Is there a lot of validating going on?... What about the "usual" NAV functionality (item/customer list, posting routines,...) - are there such big differences too?


Top
 Profile  
 
 Post subject: Re: RDP vs Client Performance NAV2009R2 with SQL
PostPosted: Mon Apr 23, 2012 8:47 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12283
Location: Brno
Country: Czech Republic (cz)
1) When running on TS - in common the TS server is connected with SQL server by backbone nework, which could be 1Gb or 10Gb, but mostly the PC is connected with 100Mb line...
2) If you are using dialog to show the progress, each update of the dialog needs to be transfered over LAN and the process in C/AL is waiting during this. RDP could cache the screen updates and thus not wait so long.
3) Regarding the dialog - best is to try toupdate the dialog only once per second or not to use during the tests.

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.


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

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


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: