Skip to content

High CPU Usage on SCCM's SQL Instance

Featured Replies

That helped me as well, after SP1, CU1, the Software Summarization was set to run every hour, and had my SQL pegged. We went from 4 to 6 cores, same thing, bumped it to 8, same thing... If you're looking for where summarization is, right click on "All Software Updates" under Software Updates in Software Library, and you'll see summarization. It was set to every hour, so I changed that to 1 day, and it's much happier now.

  • 4 weeks later...

When is there going to be a fix for this? It is very aggravating when trying to collect data about your environment. As well, yes I can set it to run once a day, but can I choose what time it runs? It is not configuration friendly.

When is there going to be a fix for this? It is very aggravating when trying to collect data about your environment. As well, yes I can set it to run once a day, but can I choose what time it runs? It is not configuration friendly.

 

I don't know of a way, if there is I would like to know as well.

  • 2 months later...

Hi everyone,

 

Just wanted to share that, in my case, after incresing server resources, some things changed but nevertheless the compsumption was still there.

 

After reviewing the logs from SQL server, we identified that a replication session from the CAS server over to its instance was completely stuck and consuming a lot of CPU resources. Just like any other Microsoft producto, we rebooted the SQL server that holds the instance, and everything is running smoothly again, we are doing some analysis to determine what caused that in the first place, but nothing has come up yet.

 

Just wanted to share this, it may help someone.

 

Regards,

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.