SCCM - SQL Server reaching 100% during Software update sync

Saravanan Balasubramanian 266 Reputation points

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 ?


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

    There's more to just that tab for WSUS maintenance - Microsoft's official documentation's here:

    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.

    You may also want to review the section:
    Specifically the processor & application pool memory sections.

1 additional answer

Sort by: Most helpful
  1. Adam J. Marshall 8,886 Reputation points MVP

    Yes you do need to.