WSUS WID Reindex

Boopathi Subramaniam 2,721 Reputation points
2021-09-09T19:51:57.027+00:00

Hello All,

I use np:\.\pipe\MICROSOFT##WID\tsql\query to connect to WID Database.

Which is the website from the below URL's can be used to reindex the WID database.

https://learn.microsoft.com/en-US/troubleshoot/mem/configmgr/reindex-the-wsus-database
https://learn.microsoft.com/en-us/troubleshoot/mem/configmgr/troubleshoot-wsus-server-high-cpu-usage
http://suneelgathcl.blogspot.com/2019/09/sccm-wsus-db-cleanup-activities.html
https://gist.github.com/emnavarro02/0ffd6481ce7c9b207f7762732fd73aa8

Please help to understand.

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
9,479 questions
Microsoft Configuration Manager Updates
Microsoft Configuration Manager Updates
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Updates: Broadly released fixes addressing specific issue(s) or related bug(s). Updates may also include new or modified features (i.e. changing default behavior).
723 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rita Hu -MSFT 9,441 Reputation points
    2021-09-10T07:06:38.76+00:00

    @Boopathi Subramaniam
    Thanks for your posting on Q&A.

    We could run the script to reindex the WSUS database. To do this, please follow the below steps:

    First of all, we could open the SSMS as an administrator first. If there is no SSMS tool in your WSUS server, please follow this link and download one.

    Then we could copy the reindex scripts in this link and run the scripts in the WSUS database - SUSDB.

    Here is a reference picture for your reference:
    130992-4.png

    Did your WSUS server integrated into the MECM? As far as I know, the script will be ran automatically when the SUP sync metadata from WSUS server next time.

    Hope the above will be helpful.

    Regards,
    Rita

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Rita Hu -MSFT 9,441 Reputation points
    2021-09-13T02:26:47.903+00:00

    @Boopathi Subramaniam
    Thanks for your feedback.

    We don't need to run the index scripts manually if the WSUS has been integrated into the MECM. I have already reviewed the wsyncmgr.log and I found the below messages and I want to share with you:

    131357-8.png

    In my opinion, some scripts will be ran to index the WSUS database when we try to sync updates next time.

    Hope the above will be helpful.

    Regards,
    Rita

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.