Dear Professional Members,
Inside our MS Windows Server 2008 R2, there were recorded more than 90% memory occupied by MS SQL Server 2008 in the part of Dynamics NAV. How to configure memory for NAV database in a proper memory allocation? As illustrated below from 2 screen shots for the memory problems:
All available memory (for MS SQL server) is being consumed constantly
(Difference between Peak and Minimum memory in use: 1.2GB only)
Next, we are installed the 2 Tiers in the Same Server (i.e. Dynamics NAV Server/NAV WS and MS SQL Server). If we delegate it into 3 Tiers into 3 Servers, can we solve the memory problem for occupying in 90%?
Hope our members can give us remedies.