MS SQL SERVER 2016 Constant CPU usage of 10% ALL DB Offline

All we need is an easy explanation of the problem, so here it is.

MS SQL Server 2016 takes 10% constant CPU usage, the usage is even if I take all the databases offline. This was never the behavior of MS SQL Server in past.CPU fan starts running in high speed. If there is no operation in background why take so much CPU. 10% of a Core I7 is too much at idle.

Machine Spec.
Windows 8.1, 6GB RAM, Core i7 2nd Gen 2.2Ghz

Diagnosed the problem see solution.

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

I found the problem and fixed it. The problem was less physical memory available. I had 90% physical memory usage after freeing up memory usage upto 84% the cpu usage went down to 0%.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply