Share via

SUSDB growing out-of-control

Duchemin, Dominique 2,006 Reputation points
2023-03-19T01:49:30.5566667+00:00

2023-03-19_15-41-02 WSUS Statuses.pdf

Hello,

I have in Configuration Manager the Software Update defined with a WSUS database SUSDB already at 1.3 TB which is growing at 3% (27 GB) a day, since February 16, 2023… The maintenance for WSUS is done every 4 hours.

SUP Cleanup 01.jpg

SUP Cleanup 02.jpg

Any idea to troubleshoot it?

Thanks,

Dom

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,289 questions
Microsoft Configuration Manager
0 comments
Accepted answer
  1. Adam J. Marshall 8,886 Reputation points MVP
    2023-03-20T03:44:57.7433333+00:00

    Is it the MDF or LDF that's growing, or both? Have you tried to see what table is causing the increase in space? If the top table is tbEventInstance, it's safe to truncate it (empty the data inside that table).

    USE SUSDB;
TRUNCATE TABLE tbEventInstance;
    1 person found this answer helpful.

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Duchemin, Dominique 2,006 Reputation points
    2023-03-22T01:54:08.5866667+00:00

    Excellent 25 GB now

    Thanks,

    Dom

    0 comments