1

So SQL server CPU ussage is around 20% even when no users are making queries

SQL CPU

I query the sysprocesses, and i can see some internal spid's:

select * from master.dbo.sysprocesses order by cpu desc

high CPU ussage process

Any idea of what is this RESOURCE MONITOR with PREEMPTIVE_XE_CALLBACKEXECUTE wait type, and why does it take so much CPU; read somewhere it can be some memory management process, but in our case we have a fixed memory reserved for SQL Server:

Memory settings

5
  • what are system specs ? how many cores, memory etc ? is it physical box, or vm ? is VM sharing resources with other VMs on a host ? – Aleksey Vitsko Oct 8 '20 at 12:53
  • What Extended Events sessions are running? Does the symptom disappear if you disable them? – Aaron Bertrand Oct 8 '20 at 12:55
  • 24GB memory, 4 cores 2,4Ghz. It's a VM, but not sharing memory; it has a fixed amount of memory assigned. – Jack Casas Oct 8 '20 at 13:00
  • For the moment we restarted the server, and the issue is gone. Our ERP system has some Ex. events, will try to stop them if it happens again. I've also reduced the minimum memory amount to 12GB; I hope this way, the memory liberation will happen more often – Jack Casas Oct 8 '20 at 13:04
  • 2
    Are any of the databases participating in an Availability Group? I ask because it looks like one CPU core is tied up (24% usage on a 4-core system), and there was a bug fixed in SQL Server 2016 SP2 CU13 related to AG health checks getting caught in an infinite loop burning up 1 core (disclosure: that's my blog), which could only be resolved by a reboot. – Josh Darnell Oct 8 '20 at 14:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.