WSUS DB Large due to tbXML table size

shockoMS 256 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.
12,200 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rita Hu -MSFT 9,626 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 256 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.