none
CPU SPIKING TO 80-100% RRS feed

  • Question

  • Not sure if it's from WordPress plugin configuration or an SQL issue, but my site continuously spikes to 80-100% CPU Usage, how would  I go about diagnosing the problem?

    Any input would be very much appreciated

    Friday, April 24, 2020 7:34 AM

Answers

  • And what OS process cause the CPU usage, your web server or SQL Server or …? Look it up in Windows Resource monitor to find the process.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, April 24, 2020 7:44 AM
    Moderator
  • Hi SBSocialSEO,

    Determine if high CPU condition is caused by SQL or WordPress plugin configuration. You can use Windows Resource monitor as Olaf mentioned.  If it is SQL and your server is hosting multiple SQL Instances identify the instance responsible for high CPU.
    Open task manager –> go to Performance tab –> click on Open Resource Monitor –> click on CPU tab and click on CPU column to arrange in descending order.

    Please refer to this blog to get more information.

    Best regards,
    Cathy 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Friday, April 24, 2020 10:17 AM

All replies

  • And what OS process cause the CPU usage, your web server or SQL Server or …? Look it up in Windows Resource monitor to find the process.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, April 24, 2020 7:44 AM
    Moderator
  • Hi SBSocialSEO,

    Determine if high CPU condition is caused by SQL or WordPress plugin configuration. You can use Windows Resource monitor as Olaf mentioned.  If it is SQL and your server is hosting multiple SQL Instances identify the instance responsible for high CPU.
    Open task manager –> go to Performance tab –> click on Open Resource Monitor –> click on CPU tab and click on CPU column to arrange in descending order.

    Please refer to this blog to get more information.

    Best regards,
    Cathy 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Friday, April 24, 2020 10:17 AM
  • ---This first thing to check if CPU is at 100% is to look for parallel queries:

    -- Tasks running in parallel (filtering out MARS requests below):
    select * from sys.dm_os_tasks as t
     where t.session_id in (
       select t1.session_id
        from sys.dm_os_tasks as t1
       group by t1.session_id
      having count(*) > 1
      and min(t1.request_id) = max(t1.request_id));

    -- Requests running in parallel:
     select *
       from sys.dm_exec_requests as r
       join (
               select t1.session_id, min(t1.request_id)
              from sys.dm_os_tasks as t1
             group by t1.session_id
            having count(*) > 1
               and min(t1.request_id) = max(t1.request_id)
          ) as t(session_id, request_id)
         on r.session_id = t.session_id
        and r.request_id = t.request_id;

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, April 26, 2020 11:30 AM
    Moderator
  • Hi SBSocialSEO,

    Any update? If the reply could help you, please mark the useful reply as answer.This can be beneficial to other community members reading the thread.
    In addition, if you have another questions, please feel free to ask.
    Thanks for your contribution.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, April 27, 2020 6:51 AM