Ask a query question and share a problem solved some time ago

awnujyicf

problem:
I have a library with more data, some tables have 4 million data, and the server is on the public network. Since there is more data, there is a query problem. When I query, I add certain conditions ( (Such as time, flashback) may take more than 10-20 minutes, the results can not come out immediately, at this time the server program on the server may behave abnormally, it feels like resources are preempted by the SQL server, and the client program executes some queries (Or querying the database on one or two machines), if one or two of the queries are abnormal, the other queries will also be abnormal. The specific performance is that if the client will prompt the query timeout, I think the sql server Isn't the query so weak? !! !! !! What we are doing is querying, but not modifying, we can do one piece of data at the same time, so this question is very unclear! Hope that experienced can help, thank you!


Resolving sharing:
Some time ago, I raised a question on this page. My database is always unable to insert data into it after running for a long time. At this time, there may be 1.2 million records in a table in the database, and then I will Delete the records, the server program can run again (run it first), this situation occurs after a short period of time, and with the deletion, the number of records in this table may be less and less, and once slowly changed It ca n’t be inserted if it is 700,000. I also asked here, it has not been resolved, and the code obtained through the server program is also foggy. One day, I suddenly wondered if there could be any help in the event log. Information, view

Automatic growth of file 'DBSERVER_Data' in database 'DBSERVER' has been cancelled or timed out after 40008 milliseconds.
Use ALTER DATABASE to set a smaller FILEGROWTH or set a new size.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

After reading the help of ALTER DATABASE, I felt a bit dizzy, and then I felt that 40008 is very strange, that is, it has grown automatically for a long time and there is no response. Then I think that my setting data file is 10%, and the initial 10% may be normal, but My data file at that time already had more than 10 G, I changed the setting to 5M each time, the problem was solved, the operation is quite normal recently, and the data file is now 28 G.

qing5636

I have recently encountered this problem and it has not been resolved.
thank you very much!

恶魔右指

The landlord is really an enthusiastic person, great field

awnujyicf

In fact, this is also a problem of too long statement execution time! I made a stored procedure in the last 2 days. When the database exceeds a certain size, the records from N days ago are deleted, but the first time I execute it, because of too much historical data, the running time is too long. Check the activity in the enterprise manager. After deleting the records of one table, it stopped in the process of deleting the next table (including pictures, the blocked spid has 18,600 items), but the server program resumed normal operation after blocking for a period of time (data not processed) speed.

Can someone explain these phenomena?

albertwl

collect it