How to adjust memory usage using configuration options in SQL Server

View (4)/comment (0)/score (0/0)

I used to call the Excel component in c # to generate an Excel applet.
PM called a few days ago to ask whySQL ServerMemory usage is so large?
Server2 GB memory is configured. The program exits after normal execution. 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 ManagementAnd Performance Monitor will show that the available physical memory on the computer steadily drops 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.

Http://space.itpub.net/16436858/viewspace-629937