SQL Server will run out of operating system memory by default,And on the server dedicated to SQL Server,In general, it is also recommended to use the memory as much as possible for SQL Server,One to improve efficiency,Secondly, it also reduces the IO loss of the hard disk。However, if there are specific circumstances that need to control the memory limit of SQL Server,SQL Server Management Studio (SSMS) To achieve。
◎ First download and install SSMS
◎ After connecting to SQL Server,Right click on the top server and select "Properties"。
◎ Click the "Memory" item,On the right you can see "Max Server Memory"
【參考連結】
- Download SQL Server Management Studio (SSMS) – SQL Server Management Studio (SSMS) | Microsoft Docs
- Adjust the memory occupied by SQL Server @ Sugar Cane at Dusk :: 随意 窝 Xuite 日志
- Research on SQL Maximum Server Memory Settings-Dark thread