About the memory usage of SQL Server.

I used to call the Excel component in c # to generate an Excel applet.
I called PM a few days ago and asked why the SQL Server memory usage is so high after the run?
The Server is configured with 2 GB of memory. After the program is properly executed, it exits. the SQL Server occupies 1.7 GB of memory and is not released.

For fear that other applications on the server may be affected, you must solve the problem or clarify the cause.

Finally, I checked the introduction of SQL Server and found that in order to optimize the performance, the original mechanism is as follows:
Http://support.microsoft.com/default.aspx? Scid = kb; zh-cn; 321363

Summary:

After you start SQL Server, the memory usage of SQL Server continues to rise steadily, even when there is little activity on the Server. In addition, the task manager and Performance Monitor will display a steady drop in the available physical memory on the computer until the available memory drops to 4 to 10 MB.

Only this status does not indicate Memory leakage. This behavior is normal and is the expected behavior of the SQL Server Buffer Pool.

By default, SQL Server dynamically increases or decreases the size of its buffer pool (cache) based on the physical memory reported by the operating system. The SQL Server Buffer Pool continues to increase as long as there is enough memory to prevent Page Swap (between 4 and 10 MB. Like other processes on the same computer as the memory allocated by SQL Server, the SQL Server Buffer Manager releases the memory as needed. SQL Server can release and obtain several megabytes of memory per second, so that it can quickly adapt to memory allocation changes.