How to configure compression in Delphix Managed Backups
Since Delphix Engine 5.2, the Delphix Engine has allowed compression to be enabled ("forced") for SQL Server backups which use Delphix Managed Backups.
Delphix Managed Backups are used to synchronize SQL Server dSources when existing SQL Server backup files cannot be made available to the Staging server, or if a third-party backup vendor is used that is not yet supported by Delphix.
For more information on this functionality, please see our documents Delphix as a Backup Solution to SQL Server and Linking a dSource from a SQL Server: An Overview.
Default behavior of Delphix Managed Backups
By default, this method of synchronizing dSources takes the following approach, which may not compress the SQL Server backup:
This behavior will compress backups in accordance with the default backup compression settings for the Source SQL Server instance, as described in Microsoft's document View or Configure the backup compression default Server Configuration Option.
Effects of enabling backup compression
Without backup compression, a 1TB database will require the following resources during a Delphix Managed Backup.
If backup compression is able to achieve a 5:1 compression ratio, this significantly reduces the network overhead:
Reasons to use backup compression
Backup compression will usually be preferable in the following situations:
The default backup compression setting for the Source SQL Server instance is Disabled (0)
The Source database does not use Transparent Data Encryption (TDE)
The Source server has available CPU resources to perform compression
Where the compression ratio of a compressed backup exceeds 3:1, this will halve the amount of data that must be transferred over the network to perform a backup. This may result in much faster SnapSync operations.
Limitations of using backup compression
Backup compression will consume additional CPU resources on your Source SQL Server host during the backup operation. For CPU-bound databases, this may be a concern, and should be discussed with your database administrators.
Note that the compression ratio achieved by backup compression will depend a great deal on your source database. Databases that contain mostly encrypted or compressed data, or which use Transparent Data Encryption, are likely to see little benefit from compressed backups.
For the most current guidance on using compressed backups, please refer to Microsoft's documents on backup compression in SQL Server.
How to enable backup compression
If the SQL Server instance's default backup compression setting is enabled (see Microsoft's document View or Configure the backup compression default Server Configuration Option), no specific action is required. Backups will automatically be compressed in accordance with this setting.
If backups are not automatically compressed, the Delphix Engine (5.2 and later) can be configured to force compressed backups using the following steps:
Login to the Delphix Engine's Management interface using your web browser
Open the Manage → Datasets screen
Locate and select the dSource using the tree on the left
Navigate to the Configuration → Data Management pane
Click the Edit (pencil) icon to modify the Validated Sync settings
The change will automatically take effect during the next scheduled Snapshot/SnapSync operation.
The following articles may provide more information or related information to this article: