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,206 questions
Microsoft Configuration Manager
0 comments
Accepted answer
  1. Adam J. Marshall 8,801 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-20T04:39:15.13+00:00

    Hello @Adam J. M

    It is the MDF that's growing, I do not have issue with the LDF.

    "Have you tried to see what table is causing the increase in space?"

    How to do this check? Yes it looks like it is the tbEventInstance table... but why is it suddenly growing so fast from 500 GB to 1.3 TB+?

    2023-03-19_21-53-35.png

    Thanks,

    Dom

    0 comments
  2. Duchemin, Dominique 2,006 Reputation points
    2023-03-20T05:11:51.2666667+00:00

    User's image

    Why do I have multiple tables tbEventInstance in th eSUSDB.mdf file?

    Thanks,

    Dom

    0 comments
  3. AllenLiu-MSFT 40,881 Reputation points Microsoft Vendor
    2023-03-20T08:48:13.6766667+00:00

    Hi, @Duchemin, Dominique

    Thank you for posting in Microsoft Q&A forum.

    How do you set the software update sync schedule?

    If it's too frequent, it may grow the tbEventInstance table quickly.

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

    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.

    0 comments
  4. Duchemin, Dominique 2,006 Reputation points
    2023-03-20T15:05:45.17+00:00

    Hello @AllenLiu-MSFT

    2023-03-20_8-04-06 SUP Sync Schedule.png

    It is synchronized daily as we are using System Center Endpoint Protection and Definition Updates are coming 4 times a day.

    I did queries on EventID & EventSourceID...

    EventID Count

    147 2316201

    148 9677304

    161 730692

    162 411117

    163 54800

    167 778893

    181 797198

    182 157756

    183 779488

    184 25317

    186 104

    187 16

    190 2

    201 90711

    361 516

    363 515

    366 28380

    382 264

    384 249

    386 2

    387 3

    389 1

    ========================

    EventSourceID Count

    101 15818973

    301 1

    302 518

    303 29411

    Any comments?

    Thanks,

    Dom