Adjust the memory limit of SQL Server

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"

 

【參考連結】

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.