January 4, 2018 at 3:41 am
Dear all,
I have my SSISDB with same big tables. I have now the correct setup in terms of version storing and in terms of data cleasing (history). So the setup is according to my expectations, including the retention period of 28 days.
Now, and this is the reson for this post, I would like also to compress data of same tables because they are big and because I believe that the main operations done agains those 3 tables are inserts, so we can use the page compression.
Tales are:
Internal.event_message (Records - 8.253.525 ; Reserved Space in KB - 8.785.376; Data KB - 8.557.960; Indexes - 225360; unused space KB - 2.056)
Internal .operation_message (Records - 8.253.525 ; Reserved Space in KB - 1.879.112; Data KB - 1.684.312; Indexes - 192.848; unused space KB - 1.952)
internal.event_message_context (Records - 4.596.654 ; Reserved Space in KB - 1.453.472; Data KB - 1.302.880; Indexes - 149.864; unused space KB - 728)
1) When I use table compression agains this 3 tables, what will I compress? the indexes or the tables them selfs?
2) Are you also using data compression on your SSISDB database?
Thnak you
January 4, 2018 at 5:58 am
I would also like to question. When I do:
ALTER TABLE [internal].[event_messages] REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
ALTER TABLE [internal].[operation_messages] REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
ALTER TABLE [internal].[event_message_context] REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE)
I am compressing the entire table.
This means that I will compress the table plus the indexes? or do I have to compress the indexes apart from the table by using the alter index command?
Thank you for the support
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply