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 Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.