Apr 22, 2020 - 07:09 AM
There is no need to worry because it is the" "normal" "behavior of SQL server. Concretely, SQL Server consumes all the memory it has to put a maximum of elements in cache and thus improve the speed of transactions. We do not recommend changing this setting.
However, if you still wish to make this change, here is the procedure to follow:
In SQL Server Management Studio, connect to the desired SQL Server database engine, right-click the desired instance and click Properties. In the Server Properties dialog box, select the Memory item from the list on the left. In the Maximum server memory (in MB) option, specify the desired maximum value. Click OK to save your changes.