Answered by:
SQL Server 2014 - RESOURCE MONITOR / PREEMPTIVE_XE_CALLBACKEXECUTE high CPU usage

Question
-
Hello,
We have newly installed 3 * Windows Server 2012 R2 Cluster+ SQL Server 2014 instances with latest hotfix installed(http://support2.microsoft.com/kb/2920151) , so the databases are still empty we haven't put any data in the environment yet, but the CPU spikes 50% on all three nodes, found the cause is Resource Monitor ( wait type: PREEMPTIVE_XE_CALLBACKEXECUTE ), but there are no audit or extended event running... the hardware is DELL, which has dsm_om* and dsm_sa* running in background, but not seems to be the cause. there is no ram pressure, nothing found in profiler...
Does anyone has any clue?
;
withcte([totalCPU])as (selectsum(cpu)from master.dbo.sysprocesses)
select
tblSysprocess
.spid
,tblSysprocess.kpid
,tblSysprocess.cpu
,CONVERT(BIGINT,(tblSysprocess.cpu *CONVERT(BIGINT,100)))/CONVERT(BIGINT,cte.totalCPU)as[percentileCPU]
,tblSysprocess.physical_io
,tblSysprocess.memusage
,tblSysprocess.cmd
,tblSysProcess.lastwaittype
from
master.dbo.sysprocessestblSysprocess
crossapplycte
order
bytblSysprocess.cpu desc
Thanks,
Albert
Friday, November 14, 2014 2:08 AM
Answers
-
Hi All,
It is solved now.
Thanks,
Albert
- Marked as answer by Lydia ZhangMicrosoft contingent staff Wednesday, December 10, 2014 9:36 AM
Friday, November 14, 2014 4:36 AM
All replies
-
Hi All,
It is solved now.
Thanks,
Albert
- Marked as answer by Lydia ZhangMicrosoft contingent staff Wednesday, December 10, 2014 9:36 AM
Friday, November 14, 2014 4:36 AM -
Hi Albert,
Thanks for your post and glad to hear that the issue is resolved. If you would like to, you can post a reply to share your solution and mark it as answer. That way, other community members could benefit from your sharing.
Thanks,
Lydia ZhangTuesday, November 18, 2014 1:35 AM -
Albert,
I have the same problem. What is the solution?
Thanks in advance.
Thursday, July 30, 2015 1:51 AM -
What was the solution? SP?
Mike Lawell MCSA: SQL Server 2012 http://www.sqlserverassociates.com Twitter: @sqldiver LinkedIn: https://www.linkedin.com/in/mikelawell
Thursday, July 30, 2015 3:48 AM