[Recommended] SQL Server actually grabs memory

Principle: The dynamic memory allocation mechanism introduced by SQL Server 2000 is generally unable to recycle the memory well. If the computer is never shut down, the memory will be exhausted. You can choose to shut down once a week to avoid it, or use the following methods to suppress memory growth.

1. Start SQL enterprise manager on the server-Microsoft SQL Server-Enterprise Manager
2. Open the console tree on the right after startup: console root directory \ Microsoft SQL Server \ SQL Server group \ (local ).
3. Right-click the (local) node and select "properties" to view an SQL server attribute (configuration) form.
4. Select "Memory" to go to the memory configuration page. Limit the maximum memory value to a certain range. Generally, the ratio is as follows:
A) if it is only used for database servers, it is 80-90% of the total memory.
B) If you are also a Domain Server, generally 60-70%
C. If you have also served as a Web server, we recommend that you set the maximum value to 60%.
5. After setting, click OK and restart the SQL Server service to make it take effect.