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.