SCCM - SQL Server reaching 100% during Software update sync

Saravanan Balasubramanian 266 Reputation points
2021-01-21T23:16:16.447+00:00

Hi Guys,

Recently i am seeing that SCCM server is at 100% CPU during the SUP sync process.
99.5% cpu time is taken by SQL server only.

we have enabled the WSUS maintenance in Config Mgr 1906 so it deletes the expired updates, and non-clustered index option is also enabled. windows search is disabled.

any pointers to fix this ? Do you guys think running SUSDB & WSUS indexing manually will help to fix this issue ?

could you suggest a link for SQL scheduled maintenance guide ?

![59276-image.png]1

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,278 questions
Microsoft Configuration Manager
0 comments No comments
{count} votes

Accepted answer
  1. Adam J. Marshall 8,886 Reputation points MVP
    2021-01-22T00:00:23.87+00:00

    There's more to just that tab for WSUS maintenance - Microsoft's official documentation's here: https://learn.microsoft.com/en-US/troubleshoot/mem/configmgr/wsus-maintenance-guide

    As for how often - WSUS Automated Maintenance (WAM) does a lot more, and has a daily, monthly, and quarterly setup that's all automated by the scheduled run.

    https://www.ajtek.ca/blog/how-to-clean-up-wsus-database/

    You may also want to review the section: https://www.ajtek.ca/wsus/wsus-system-requirements-what-should-i-plan-for/
    Specifically the processor & application pool memory sections.


1 additional answer

Sort by: Most helpful
  1. Adam J. Marshall 8,886 Reputation points MVP
    2021-01-22T00:20:43.227+00:00

    Yes you do need to.