SQLTeam.com | Weblogs | Forums

How to reduce the memory usage in sql server 2016

Hi All,

When Running applications that time sql server Memory usage 95% taken it is ok but

When No Application running the time also memory usage 95% shown in Task manager.

My Problem is when application not running that time memory not used is better me.

how to reduce the system memory usage when application not running time.



That's the normal behavior of SQL server handling memory. It will keep the memory with it. It will only release when explicitly requested by the OS.
Better is to configure min and max memory setting for SQL server.

If you want to reduce memory usage then you, are required to decrease the downtime of SQL Database.

What does downtime of SQL Server databases have to do with Memory Usage?