Set a Fixed Amount of Memory (SQL Server Management Studio)
Some times the SQL database uses large
amount of RAM on the server which causes issues on the server, you can
set a fixed amount of memory using the below steps.
-
In Object Explorer, right-click a server and select Properties.
-
Click the Memory node.
-
Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory.
Use the default settings to allow SQL Server to change its memory
requirements dynamically based on available system resources. The
default setting for min server memory is 0, and the default setting for max server memory is 2147483647 megabytes (MB).
No comments:
Post a Comment