SQL Server Memory problems (favorites)-database columns, SQL Server

SQL Server Memory problems (favorites)-database columns, SQL Server
A traffic statistics function is currently being developed. The data volume is in the thousands or even thousands. During each statistics, the SQL memory usage is large. After the statistical stored procedure is executed, I found that the memory usage of SQL will not be released. See some experts who say that this is a mechanism of SQL to improve the efficiency of next access. Maybe, in the process of searching for a solution, I found the following post, which is comprehensive and has been filed for record;

Http://www.richsearch.com/search/search.aspx? Page = 1 & S1 = % 2B % E5 % 86% E5 % ad % 85% 98% 2B "SQL % 20 server"
Allocate more memory to sqlserver (the default value is dynamic allocation. You can change the minimum value to a relatively large data value ).
View and adjust the size of the database log files and data files.
-----------------
The insert record is slow, probably because the table uses the clustered index, and the new record causes the storage location of a large amount of data to change.
Http://www.delphibbs.com/delphibbs/dispq.asp? Lid = 2037790

From: shaoyy, time: 9:25:00, ID: 2636792 [display: small font | large font]
A pos system in our company, with the SQL server at the backend and ADO at the front end. Now it is ADO + Midas. This problem often occurs in the past two years: when the system is very busy (when the mall business is good), the SQL server will become unresponsive, and then all the front ends will crash. One or two times a month will occur, and it has been searching for a long time, are there any problems with SQL Server or programs? If you have any experience in this area, please kindly advise and give me some tips. Thank you!
Http://www.delphibbs.com/delphibbs/dispq.asp? Lid = 2636792

The database has the ability to adjust itself to a large extent. As the memory increases, SQL Server will expand the memory usage space. When the memory pressure from other applications increases, SQL Server will release part of the memory space. Similarly, SQL Server will dynamically expand or contract the database and log space as needed.
Http://www.microsoft.com/china/technet/prodtechnol/ SQL /2000/plan/ssmsam.mspx

By the way, I am a securities software company with a data volume of more than 0.1 billion pieces. SQL Server often eats 2-4 GB memory.
But the system runs well.

In fact, it is not that simple.
MSSQL is faulty in memory release.
If it is really massive data (the so-called massive, not just 100 or 200 GB), you will find that
For a short period of time, if you contact for a large number of queries, it
Memory usage will continue to rise, and the database speed will obviously decrease,
At this time, if you restart the system, you can solve the problem.
I have contacted Microsoft and have no good solutions.
Later, we made several components to improve its efficiency. Although the effect was not very good, it was acceptable.
Such as databases, especially MSSQL, is not very useful in the case of a large amount of data.
However, it is easier to connect to Microsoft's own operating system. Well,
So I had to use him.
Http://www.delphibbs.com/delphibbs/dispq.asp? Lid = 1775126
Use Oracle instead.
Http://www.delphibbs.com/delphibbs/dispq.asp? Lid = 287033

The server memory is 1 GB. After two days, you can use the task manager to observe that the memory usage is more than MB,
Among them, the thread sqlservr occupies the most, and the number of customer connections is only a few.
Http://www.delphibbs.com/delphibbs/dispq.asp? Lid = 2144996

The following article may be helpful to you:
Http://www.ck23.com/net/html/2003-7-27/2003727151935.htm
Do not use server-side cursors in Delphi; otherwise, the memory on your server will soon be consumed.
Http://www.delphibbs.com/delphibbs/dispq.asp? Lid = 2144996

As mentioned above, this is the advantage of SQL Server, because it provides buffer memory, even if the user is temporarily offline,
It also does not release all the caches.
Of course, it will not occupy the memory and never release it. Once it detects that the memory allocated by the operating system is insufficient, it will
Release the memory in time. Do not believe you can perform this check. After the User goes offline, it will take up so much to run Photoshop on the server.
Test the software with a large system memory to ensure that SQL Server releases some memory at this time.
Http://www.delphibbs.com/delphibbs/dispq.asp? Lid = 2353948

Article: Star candle Web site: http://www.xingzhu.net.cn/
The above information is an integral part of the text. If you want to reprint this article, please keep the above information. Thank you!