If you encounter the SQL Server service caused the memory to expand the final system crash, please resolve the following method.
Principle: The dynamic memory allocation mechanism introduced by SQL Server 2000 is generally unable to recover memory. If the computer is not closed, the memory can be exhausted. You can choose to avoid the growth of memory every week to avoid it, or in accordance with the following method.
1. Start on the server - Microsoft SQL Server-Enterprise Manager to start SQL Enterprise Manager
2, open the right console tree after startup: Control Bengen Directory / Microsoft SQL Server / SQL Server Group / (Local).
3. Right click on the (local) node, select the Properties menu, you can see a SQL Server property (configuration) form
4. Select the "Memory" tongue to open the memory configuration page. Limit the maximum value of the memory within a certain range, generally followed by:
a) If you only use only for the database server, 80-90% of the total memory
b) If the domain server is part, it is generally 60-70%.
c) If it also serves as a web server, it is recommended to have a maximum of 60%.
5, click OK, then restart the SQL Server service to take effect.
