mibuso.com

Microsoft Business Solutions online community
It is currently Tue Oct 21, 2014 2:37 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Navision Client performance difference
PostPosted: Fri May 18, 2012 9:05 am 
Offline

Joined: Fri Feb 20, 2004 2:09 pm
Posts: 39
Location: Offenburg
Country: Germany (de)
Hello ,

We are facing a performance difference on SQL Server transactions between a some servers on wich Navision Clients are running.

Let me try to explain our problem:
We are running Navision 5.1 Clients on citrix servers and another Server running NAS. All Servers are virtualized.
SQL 2008 R2 Server is not virtualized.
As we discovered a perfomance problem on the NAS Server i set up a little benchmark function with somme find and calcfields operation, and ran this funktion on both environments with Standard Client.

Looking on Client Monitor:
On Citrix Server : 6 sec, 320 DB Operations with 16 Ms , all others with 0
On NAS Server : 26 sec , 1516 DB Operations with 16 Ms , all others with 0

We have checked the virtualization environment running the server on the same boxes.
Another fact is that running the function on the citrix client for the first time it also took 26 s , the second time only 6 s.
on a local client it takes 6 s the first time, on the NAS Server box it takes 26 s everytime.

Open connection problem ? Caching ?

Any advice is appreciated.


Top
 Profile  
 
 Post subject: Re: Navision Client performance difference
PostPosted: Fri May 18, 2012 11:39 pm 
Offline

Joined: Mon Mar 12, 2007 3:07 pm
Posts: 365
Location: Hamburg
Country: Germany (de)
Check the object cache setting of the NAS.

You might also want to copy a normal client to the NAS Box and run the same benchmark there. Check with different object cache settings.

_________________
Frank Dickschat
FD Consulting


Top
 Profile E-mail WWW  
 
 Post subject: Re: Navision Client performance difference
PostPosted: Sun May 20, 2012 9:29 pm 
Offline

Joined: Fri Feb 20, 2004 2:09 pm
Posts: 39
Location: Offenburg
Country: Germany (de)
Quote:
I ran this funktion on both environments with Standard Client.


the slow performance is allready on a standard client running with normal object cache.
On both Server : Objet Cache 32000 KB


Top
 Profile  
 
 Post subject: Re: Navision Client performance difference
PostPosted: Wed May 23, 2012 2:07 pm 
Offline

Joined: Fri Feb 20, 2004 2:09 pm
Posts: 39
Location: Offenburg
Country: Germany (de)
The Object are cached normally on both Client.

A deeper check in Client Monitoring shows that the SQL Cursors und SQL Plans used in both environment
are the same.

Quote:
10794 FIND/NEXT 33 SQL Status ID: 18981;Reused: 29;Prepared;Dynamic;Restricted;Rows: ;Cached;UpdateNoLocks

10795 CALCSUMS 33 SQL Status ID: 4756;Reused: 3561;Prepared;Default;Rows: 1;UpdateNoLocks

10796 FINDFIRST 33 SQL Status ID: 4759;Reused: 3561;Prepared;Default;Top;Rows: 1;UpdateNoLocks



As shown above only a major part of SQL Querys have a duration of 16ms on the NAS Box.

Does that refer to a network problem ?


Top
 Profile  
 
 Post subject: Re: Navision Client performance difference
PostPosted: Wed May 23, 2012 4:33 pm 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Thu Jul 31, 2003 12:00 pm
Posts: 640
Location: Nürnberg
Country: Germany (de)
Well, I suggest to run SQL Profiler to trace the queries to see what EXACTLY takes so long ... In parallel I'd run "Windows Performance Monitor" to check on the disks and the network (maybe also CPU and RAM) - here monitoring both: the SQL Server machine and the NAS or Citrix box!

_________________
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  
 
 Post subject: Re: Navision Client performance difference
PostPosted: Thu Jul 05, 2012 8:52 am 
Offline

Joined: Fri Feb 20, 2004 2:09 pm
Posts: 39
Location: Offenburg
Country: Germany (de)
Hello,

We investigate this problem a little further and find some issues.

Running our little benchmark tool from citrix navision client and a call it "slow server Navision Client" , we found following results:

Both runs have the same execution time on the SQL Server Trace 0,6 Sec. for 4595 SQL Statements.
Analysing in details show that the run from citrix client fires 5 SQL Statement within the same millisecond, the "slow server"
fires 1 SQL statement per Ms.

In the end we find her the 1 / 5 relation in the total runtime duration.

Both Servers are running as virtual servers in the same network.
The Citrix Server is in the domain.
The slow server is attached to the sql server via a firewall.

Do you think that the firewall could be the problem ?

Thanks again for every reply , suggestion


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 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: