SQL statement memory-consuming query Solution

Source: Internet
Author: User
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.