Post reply

Troubleshooting High Cpu per session

  • September 12, 2016 at 9:19 am

    #321461

    Hi All

    I am using Idera SQL Diagnostic Manager to try and help trouble shoot a 3rd party application problem. I look at 'Active Sessions' and there can be 3 sessions running without any physical i/o and cpu utilization is at 50%. This 3rd party database is the only database on the SQL Server box--which is running Windows 2012R2. The database is set at compatibility level SQL Server 2012. I know this is limited information but by any chance is there anyone who has seen high cpu with so little going on and what have you looked into?

    Thanks

    Kathy

  • September 12, 2016 at 9:27 am

    #1900349

    Start with the obvious. Is it SQL Server using the CPU?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 12, 2016 at 9:30 am

    #1900350

    Yes it is sql cpu--Thanks for the input

  • September 12, 2016 at 9:32 am

    #1900351

    As in, at the OS level check and make sure that the SQL Server executable is the process using that 50% CPU.

    Have you done that?

    Is SQLServr.exe the process using 50% CPU all the time?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 12, 2016 at 9:56 am

    #1900356

    Yes I have checked in task manager to find out that sqlservr.exe is utilizing the 50%.

    Thanks

    Kathy

  • September 12, 2016 at 10:05 am

    #1900362

    Then you're going to have to dig into what's happening on that SQL Server and see where the CPU usage is coming from.

    Chapter 3 of https://www.red-gate.com/library/troubleshooting-sql-server-a-guide-for-accidental-dbas might help

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 12, 2016 at 10:12 am

    #1900364

    Quick question, any scalar or multi statement table valued functions in the 3rd party code?

    😎

  • September 12, 2016 at 11:51 am

    #1900381

    SQL Diagnostic Manager offers lots of options for showing you what queries are eating various resources.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • September 12, 2016 at 11:58 am

    #1900383

    Thanks for all the reply's. It seems that main issue was a network problem.

  • September 12, 2016 at 12:30 pm

    #1900389

    kathy.plamann 36011 (9/12/2016)

    Thanks for all the reply's. It seems that main issue was a network problem.

    How was your high CPU utilization related to the network?

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply