question

BoopathiSubramaniam-6294 avatar image
0 Votes"
BoopathiSubramaniam-6294 asked RitaHu-MSFT commented

WSUS WID Reindex

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://docs.microsoft.com/en-US/troubleshoot/mem/configmgr/reindex-the-wsus-database
https://docs.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-update-servicesmem-cm-updates
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

The case is related to WSUS, so I remove the tag of SCCM, add the tag of WSUS.

Best regards,
Amanda

0 Votes 0 ·

@BoopathiSubramaniam-6294
It seems that there are no updates for a long time. May I know the status of the case?

Don't hesitate to keep us in touch if you have any questions. Please be kind to share your solution on this forum if the issue has been resolved.

Thanks for your time and have a great day.

Regards,
Rita

0 Votes 0 ·
RitaHu-MSFT avatar image
0 Votes"
RitaHu-MSFT answered BoopathiSubramaniam-6294 commented

@BoopathiSubramaniam-6294
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.


4.png (58.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello RitaHu,

thanks for your reply.131097-capture.jpg


131153-2.jpg
WSUS server integrated into the MECM.


0 Votes 0 ·
capture.jpg (67.4 KiB)
2.jpg (102.1 KiB)
RitaHu-MSFT avatar image
0 Votes"
RitaHu-MSFT answered RitaHu-MSFT commented

@BoopathiSubramaniam-6294
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.


8.png (32.9 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello Rita,

Thanks.
I am also seeing the same message in wsyncmgr.log.
131577-wid.jpg



SQL services of WID is taking more CPU and Memory.CPU Load: 25 % %Memory Used: 97 %
Please suggest what is to be done.

0 Votes 0 ·
wid.jpg (101.0 KiB)
RitaHu-MSFT avatar image RitaHu-MSFT BoopathiSubramaniam-6294 ·

@BoopathiSubramaniam-6294
Thanks for your feedback.

I found a related link. Please follow this link to open SSMS and Procedure for configuring a fixed amount of memory.
Reference picture:
131746-9.png

Hope the above will be helpful.

Regards,
Rita


0 Votes 0 ·
9.png (78.2 KiB)