Troubleshooting: Decreased Performance When Running Reports in the Microsoft Dynamics NAV Web Client
When many users regularly run reports from the Microsoft Dynamics NAV Web client, the memory consumption by the Internet Information Server will grow slightly over time. If the Microsoft Dynamics NAV Web Server components and SQL Server are on the same computer, the report performance may degrade because the SQL Server computer becomes deprived of memory.
To resolve this issue, you can do the following:
In SQL Server, increase the minimum server memory option for the server instance that is used by Dynamics NAV. You can do this by using SQL Server Management Studio. By default, the minimum server memory is 0 MB. For example, start by increasing the minimum server memory to 512 MB. For more information, see Server Memory Server Configuration Options.
In IIS, change the recycle period of the application pool that is used by the Microsoft Dynamics NAV Web clients. You can do this by using IIS Manager. Recycling the application pool restarts worker processes in an application pool, which can help recover valuable system memory resources. By default, the application pool is set to recycle every 1740 minutes (29 hours). For example, decrease the application pool to recycle once a day (every 24 hours) at a time that is outside of peak operating hours. For more information, see Application Pools.