Details about us:
Currently live with AS400
Around 10 concurrent users are doing light tests in NAV
Large customer base with a lot of telesales both b2c and b2b, so reducing any stuttering during the creation of orders is crucial.
Dynamics NAV 2017
MS SQL Server 2016
We have one VM with an SQL Server for a Dynamics NAV Database and one VM with a ServiceTier. Every now and then we're running into performance issues most of those having to do with our 4,5 million customers. (like looking up their balance or trying to select one in a sales order)
I would've expected that having more than one ServiceTier with enough power and data cache should solve the issue. Right now it seems as though the ServiceTier is only handling the business logic and not actually caching the data and therefore lowering the load for the SQL Server.
Am I missing something in the settings or is the 3-Tier Architecture not meant to lower the load for the SQL Server? Of course there's things we can accomplish by adjusting the programming but it's happening with stock standard NAV functionalities.