SSISDB page compression on big table is ok?

Alen Cappelletti 992 Reputation points
2024-06-12T20:53:53.1266667+00:00

Hi all,

I've just ended a ssis migration on a dedicated machine and today is the real first day run.

I reduce the logging on the SSIS step to BASIC (but I would like to set to NONE).
There are so many SSIS with HIGH frequency and from this morning ssdb datafile is close to 7Gb... in the old server is a HUGE db.

Naturally I've set a low retention...

User's image

2 Question:

  1. I would like to use PAGE compression on larger tables... but being a system DB I don't want any surprises, what do you think? Is it ok anyway? I have never done this on an SSISDB, but many times on others.
  2. If I set NONE to the logging TAB
    User's image

the default will become the
User's image
User's image

I must have in my archive some references to articles that explained the customization of deletions in order to make the tables more slim... but I think it all refers to the retention of the days that I am going to insert... or is something over?

THANKS for your time.

ALEN

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,183 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 34,756 Reputation points
    2024-06-13T05:48:12.92+00:00

    Hi @Alen Cappelletti,

    You may check the blogs to see if it is helpful.

    SQL Server Integration Services Catalog Best Practices

    Managing the size of the SQL Server SSIS catalog database

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments