Compress Configuration Parameters
MinSpaceMB
Specifies the minimum database size below which compress is not performed.
MaxSpaceMB
Specifies the maximum database size above which compress is not performed.
FreeSpacePercentage
Specifies the minimum free space that we are likely to claim back if compression is performed. For example, if current database size is 5 GB, and free space threshold is 40, then compression will be performed only if we are likely to release at least 2 GB of free space.
Default configuration of compression setting to ensure we compress large databases to gain a minimum of 50% space.
MinSpaceMB - 0, MaxSpaceMB - 10000, FreeSpacePercentage - 0
Note:
This setting compresses database of size 10 GB or less during startup.
MinSpaceMB - 10000, MaxSpaceMB - 2147483647, FreeSpacePercentage- 50
Note:
This setting compresses the large databases of size over 10 GB to release a minimum of 50% of the space