TIL: SQL Server uses all available memory

from blog Just Some Code, | ↗ original
SQL Server tries to use all available memory. SQL Server allocates memory during its activity. And, it only releases it when Windows asks for it. This is normal behavior. SQL Server caches data into memory to reduce access to disk. Remember, SQL Server caches data pages, not query results. You can limit the amount of memory available by setting...