Post reply

how to decrease the size of the base ssisdb ?

  • July 27, 2018 at 10:13 am

    #407253

    Hello everyone
    I am looking to decrease the size of my base ssisdb?
     I have not much of the deplayer package on the service integration cataloge
    What is the good practice?
    thank you for your help

  • July 31, 2018 at 2:24 pm

    #1999780

    joujousagem2006 1602 - Friday, July 27, 2018 10:13 AM

    Hello everyone
    I am looking to decrease the size of my base ssisdb?
     I have not much of the deplayer package on the service integration cataloge
    What is the good practice?
    thank you for your help

    Monitoring the the cleanup process and retention window would be an important part of good practices. Read the following for more information on managing this:
    Managing the size of the SQL Server SSIS catalog database

    I can't tell for sure if the size has gotten a bit out of control but there is some additional information in this link.  Remember to be careful about the shrinks:
    How to Reduce SSISDB Size

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply