Share via

WSUS DB Large due to tbXML table size

shockoMS 281 Reputation points
2021-09-27T20:43:43.377+00:00

On my of my WSUS servers (Upstream and downstream) the DB has grown to over 15 GB. Our estate is small (~1400 windows machines). I notice that the table tbXML is ~ 6 GB. It seems to contain localization data or the like. I'm only selecting English under Options -> Update Files and Languages File -> Update Languages

Does anyone know the purpose of this or how to safely clear it down?

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,414 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rita Hu -MSFT 9,641 Reputation points
    2021-09-28T02:35:50.087+00:00

    @shockoMS
    Thanks for your posting on Q&A.

    I don't know what the actually datas are included into the table tbXML. There is no such Official Document for reference. But I tried to test it in my lab and I would like to sahre the test result with you.

    I ran this PowerShell Scripts to decline the Superseded updates and run the Server Cleanup Wizard. Some datas are deleted from the table. Here is the screenshots for you:
    135731-2.png

    135741-3.png

    135751-10.png

    Hope the above will be hlpful.

    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.

    1 person found this answer helpful.
    0 comments
  2. shockoMS 281 Reputation points
    2021-09-28T09:07:27.533+00:00

    Thanks! That's good info. I'll haver a look at my own environment and see what updates seem to tie in to this table.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.