Troubleshoot SQL Server running out of memory

If you encounter a situation where the SQL Server service causes memory to continue to expand the final system panic, please follow the methods below.

Principle: The dynamic memory allocation mechanism introduced by SQL Server 2000 generally does not reclaim memory well, and if the computer does not shut down, memory exhaustion may occur. You can choose to shut down the machine once a week to avoid it, or to suppress the growth of memory in the following ways.

1. Start SQL Enterprise Manager in-microsoft SQL server-Enterprise Manager on the server
2. After startup, open the console tree on the right: Console Root \microsoft SQL Server\SQL Server group \ (Local).
3. Right-click on the (Local) node and select the Properties menu to see a SQL Server properties (configuration) Form
4. Select the "Memory" tab to open the Memory configuration page. Limit the maximum amount of memory to a certain range, typically in the following proportions:
A) 80-90% for total memory if only for the database server
b) If you are a domain server, typically 60-70%
c) If you are also a Web server, the maximum recommended is 60%
5. Click OK when you are finished, and then restart the SQL Server service for it to take effect.