WSUS WID Reindex

Question

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.

Answer 1

@Boopathi S
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:

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.

Answer 2

@Boopathi S
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:

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.