The principles of managing system memory by Sqlserver .
Allocate as needed and be greedy (use up but not return). It does not automatically release memory, so when executing SQL statements with a large result set, after data retrieval, it will continue to occupy memory until it fills up the machine memory (it will not be full, there is still a maximum limit, slightly smaller than machine memory). Before restarting the service, SQL server will not release this memory, and there is no way to artificially release it. Although the following command can release the cache, SQL Server will not release the occupied memory as a result.
influence .
Causing slow machine operation, deadlocks, etc.
Solution .
Manual modification; Maximum server memory", The default is 2147483647M. 64 bit systems do not require AWE to be enabled, as AWE is required for 32-bit systems to use over 4G physical Only memory is used.
At the same time, it is best to cooperate with Druid for data source monitoring.
Reference: