Dynamics Nav 2009 Native db on citrix

Hi

The company I work for has a Dynamics NAV 2009 R2 using the native db (200 GB) we access Navision from a remote desktop provided by a hosting center, the hosting center are planning to upgrade from Windows Server 2008 to Server 2016 and starting using citrix instead of remote desktop.

We have a test environment with a recent copy of our database and the performance is very bad I’m not sure if it's citrix or windows 2016 server which are causing the problems, a test report takes 4 times longer to run on the test client than in our production environment, if I install a client on the test Navision server the report runs very fast like 10 times faster than on the test client, but if I run a report which create an excel file the test client is faster than the test server.

The hosting center has tried to increase the resources on the server but this gives no increase in performance.

Any help would be appreciated

BR

Peter

  • Citrix will always be slightly faster than Remote Desktop. The difference though in current versions is not as pronounced as it was in earlier versions, so I would not focus on that aspect at this point.

    The most likely area to start looking is the actual configuration of the Servers. Native database is very unforgiving on how the drives and commit cache are configured, and very few Hosting providers are aware of this, so they probably just set it up as they would a SQL server, which just wont work.

    Unfortunately without specific data it is nearly impossible to provide answers. The list of things to look for is a big list. This is the sort of job that needs to log into the system and review everything methodically step by step.

    Before I moved to SQL Performance tuning I did many Native database tuneups, and the god news is that it is generally quite easy to resolve the issues, it just takes time and testing to work out exactly what to do.
  • In reply to David Singleton:

    Hi David

    Thank you for your answer, I have asked the hosting center to contact a specialist to solve the problem

    You mentioned drivers, is it primarily the net card drivers they need to check ?

    BR

    Peter
  • In reply to filuren:

    Hi David

    Ignore my previous post, I read "drives" as "drivers"

    BR

    Peter
  • In reply to filuren:

    I doubt an IT guy is going to resolve this. You need someone that understands the Navision Native database to resolve this. The Hosting company wouold most likely come back with a reply like "Well it works for SQL why wouldn't it work for Navision?"
Related