Solution to SQL Server memory encountering operating system process squeeze

Source: Internet
Author: User
Tags resource server memory

Scene:

A recent DB server occasional CPU alarm, my email alarm threshold (Please read yù) value set is 15%, the beginning is not the case, thinking is what the statistical category of inquiries, and then more frequent.

Explore:

I decided to check to see what was going on, and the Order of my troubleshooting was as follows:

1, first turn on cacti monitoring, found that the most recent CPU average after a day suddenly rise, and can see system\processor Queue Length and Sqlservr\%processortime also in significant changes.

2, starting from the most easy to start the low efficiency of SQL, consider what is the latest business changes? Connect to the SQL instance, open the Activity Monitor, expand the "most recent resource-intensive queries," and reverse CPU time, where there is no immediate resource-intensive query. According to personal experience, here, if the value is 4 digits, 3 digits in minutes, the general server CPU is probably more than 10%, if the CPU time there is 5 digits, and the number of minutes in the execution is also very high, hundreds of times, the CPU will generally not calm. Pictures for demo only

Related Article

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.