Post reply

SQL Server 2014 CPU Pegged at 100%

  • March 26, 2017 at 9:32 pm

    #336270

    Hi,

    We have a Virtual Machine on VMWare which is a core production DB server and the IT guy allocated it 6 processors.
    CPU is pegged at 100% all the time,

    Based on google-  I set maxdop=6 , cost threshold of parallelism= 50  and max worker threadsm still its pegged,

    Any idea how to fix or just have him add 6 more processors?

    Thanks

  • March 27, 2017 at 1:09 am

    #1935013

    Tune your queries to use less CPU.
    https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server-part-1/
    Article's a tad out of date these days, use Extended Events not Profiler. Methodology's the same though.

    And don't fiddle with max worker threads unless you have diagnosed thread starvation (which is a rare problem). Set it back to default.

    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

Viewing 2 posts - 1 through 1 (of 1 total)

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