SQL statements involve queries that consume a large amount of memory (such as sorting and hash operations). If the memory is insufficient, it is caused by waiting in queue for resources. This is a problem many developers encounter. Today we provide some solutions, hope to be useful to you.
SQL statements involve queries that consume a large amount of memory (such as sorting and hash operations). If the memory is insufficient, it is caused by waiting in queue for resources. This is a problem many developers encounter. Today we provide some solutions, hope to be useful to you.
Solution:
A. Optimize statements to create/use suitable indexes;
B. To solve the first problem, UPDATE the index distribution STATISTICS of the table to be queried to ensure the correctness of the estimated time. UPDATE the STATISTICS table name;
C. Increase the memory.
To manually set query timeout, use the following statement:
| The Code is as follows: |
|
Sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
Sp_configure 'query wait', 2147483647
GO
RECONFIGURE
GO
|