Forum Discussion

SteveUpchurch's avatar
SteveUpchurch
Copper Contributor
Nov 11, 2020
Solved

SharePoint SQL Server at 100% CPU Utilization

If this has been addressed, I apologize.  I have a situation where my SharePoint SQL server will periodically spike to 100% CPU utilization and render SharePoint unusable.  I have a four-server Share...
2013
admin
sharepoint server
  • Trevor Seward's avatar
    Trevor Seward
    Nov 11, 2020

    SteveUpchurch I don't think anything is "wrong", per se. It's just an expensive query (indeed this had pref problems as recently as this year in SPO). As to what exactly is generating the query, I'd have to go sproc hunting 🙂

     

    Curious to know if you've applied any patches recently and/or if you're at the Nov 2020 CU level, yet.

7008332020's avatar
7008332020
Copper Contributor
Nov 11, 2020
yes
  • SteveUpchurch's avatar
    SteveUpchurch
    Copper Contributor
    Nov 11, 2020

    7008332020 What is generating that query, if known?

Resources