RDP vs Client Performance NAV2009R2 with SQL

bertoos
Member Posts: 19
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
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
0
Comments
-
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.0
-
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 Consulting0 -
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?0 -
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,Bert0 -
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 insertions0 -
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.0 -
It's understandable why perfomance on Remote Desktop Server is better than on local client, it must be so, as I unserstand.
But we have a REVERSE SITUATION, how about this?
For a long time it was ok, but now we encountered with the situation, when the same actions take more time using Terminal Server, unlikely local client.
Even when users work in the office connecting by LAN-cord. Both SQL and Terminal Server are on Failover Cluster w/ 1Gb switch between nodes.
Does anyone have any ideas?0 -
Some guesses:
-virtualized server: maybe hardware changed and it is not on high performance but on battery saving.
-Something new installed on the server that is eating resources.
-overprovisioning. too many users on 1 server. or too many VM's on the physical server.
-problem on the network between terminal server and SQL Server.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
Our 3rd party NAV suuport helped to solve the problem.
Thanks for guesses, but all of them are not appropriate to our situation.
They suggest, that local NAV 2009 R2 Classic (with SQL) Client from workstation uses cached ACLs and doesn't query AD so frequent. But, on RDS (we call terminal server such) NAV before evrey single action NAV queries AD for permissions - that's why we were constantly seeing "Поиск по таблице Контроль доступа Windows" - approx. "Searching in Windows Access Control table".
They help us. Now NAV on RDS queries ACLs once, when client starts.
Hope, my english is sufficient to understand me correctly0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions