-6

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.

closed as unclear what you're asking by Tom V, Shanky, Kin Shah, Philᵀᴹ, mustaccio Dec 5 '16 at 15:38

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Ok .. so what is your concern .. should it be taking 50% or 80% CPU ? What kind of activity is going on on the server ? – Kin Shah Dec 5 '16 at 14:57
  • No activity but CPU usage is taking 8% to 10% all the time. This was not a case in SQL SERVER 2008 or 2005. – Muhammad Yousaf Sulahria Dec 5 '16 at 14:59
  • If there is no activity, burning CPU is just a waste. Its OK to have less than 10% CPU when there is no activity. – Kin Shah Dec 5 '16 at 15:00
  • 10% CPU usage is by the SQL server process in Process Monitor. – Muhammad Yousaf Sulahria Dec 5 '16 at 15:03
0

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%.

  • You should have your max memory set away from default .. e.g. 4 or 4.5 GB. – Kin Shah Dec 5 '16 at 15:20

Not the answer you're looking for? Browse other questions tagged or ask your own question.