SQL Server does not kill queries that Dynamics NAV does

Hugo Fernando Miranda Morin 26 Reputation points
2021-02-26T20:27:10.04+00:00

Hello,

I have the following scenario, I have Dynamics NAV 2017 working in a Virtual Machine in Azure, everything is fine until a search is made for a record in Dynamics NAV, the SQL service increases the use of RAM memory up to 96% and the search on the platform ends but SQL continues to consume the resources. The way we have found workaround for the moment is to stop user access in Dynamics NAV, stop the SQL Server service and start it again and allow user sessions in Dynamics NAV. Any similar experience and possible solution?

Thanks

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,070 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. Erland Sommarskog 103.5K Reputation points MVP
    2021-02-26T22:40:21.74+00:00

    Adding to what Tom says, this is to be expected. If this is a problem because there are other processes on the machine, you may want to restrict how much memory SQL Server can grab with the configuration option "max server memory".

    Else, I would say that the solution is to sit on your hands and do nothing.