gotchasqlMinor
Please explain the difference between row and page compression
Viewed 0 times
thepleasecompressiondifferencebetweenpageandexplainrow
Problem
I'm trying to determine which to apply and when is the appropriate time to apply compression. I'm posting this question to get insight from this community. I have read several articles, but wanted to have a place where this addressed in DB Administrators.
Solution
In order to make a decision for bunch of tables you can run procedure "sp_estimate_data_compression_savings":
That will help you determine savings for each particular table.
From my experience PAGE compression works better in most of the cases.
exec sys.sp_estimate_data_compression_savings @Schema,@Table,NULL,NULL,ROW;
exec sys.sp_estimate_data_compression_savings @Schema,@Table,NULL,NULL,PAGE;That will help you determine savings for each particular table.
From my experience PAGE compression works better in most of the cases.
Code Snippets
exec sys.sp_estimate_data_compression_savings @Schema,@Table,NULL,NULL,ROW;
exec sys.sp_estimate_data_compression_savings @Schema,@Table,NULL,NULL,PAGE;Context
StackExchange Database Administrators Q#141464, answer score: 8
Revisions (0)
No revisions yet.