locked
SSISDB is consuming more space in server RRS feed

  • Question

  • Hi Team,

    My SSISDB consuming more than 100 GB . When am check in tables size have find 3 tables consuming more space.

    Tables are :

    internal.event_message_context, internal.event_messages and internal.operation_messages

    Also retention period’s set 365 Days.

    Please help on the above issue. How to reduce my SSISDB size.


    Thanks Bala Narasimha

    Wednesday, April 8, 2020 5:15 AM

Answers

  • Hi BaluChalla,

    Step-1:Update the retention values from 365 to 3 days or whatever old history you want to keep.

    Step-2:Alter procedure “SSISDB.[internal].[cleanup_server_retention_window]” SET @delete_batch_size=1000

    instead of 10, in case if your DB size grown more than 10 GB.

    Step-3:Run the below query to Compress the tables data.

    Step-4:Then using below queries Shrink the database if size is more than 10 GB.

    The following links will be helpful:

      How to Reduce SSISDB Size

      SSISDB is 100gb how to reduce size with out affecting etl packages

    Best Regards,

    Mona


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by BaluChalla Wednesday, April 8, 2020 10:12 AM
    Wednesday, April 8, 2020 6:19 AM