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