Solution to SQL Server memory encountering operating system process squeeze

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