locked
SQL Server 2014 - RESOURCE MONITOR / PREEMPTIVE_XE_CALLBACKEXECUTE high CPU usage RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All,

    It is solved now.

    Thanks,

    Albert

    Friday, November 14, 2014 4:36 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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 Zhang

    Tuesday, November 18, 2014 1:35 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Albert,

     I have the same problem. What is the solution?

    Thanks in advance.

    Thursday, July 30, 2015 1:51 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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