Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.8 - Integration with TSM Guide

Compression Levels

You can specify a compression level manually, or you can use Adaptive Compression to let LiteSpeed automatically select the optimal compression level. For more information, see Adaptive Compression.

LiteSpeed offers the following compression levels that allow you to specify compression from least compression to most compression, with a corresponding CPU trade-off.

Compression Level Description
1 Medium Compression—for servers where minimal CPU utilization is preferred at the expense of some compression.
2 Medium-High Compression—a new highly optimized low CPU algorithm for environments where low CPU utilization is preferred but with improved compression over level 1.
3, 4, 5, 6 High Compression—for databases where balanced compressed backup size and CPU utilization is important.
7, 8

Extreme Compression—a new highly optimized extreme compression algorithm for databases where compressed size is very important with only a slight increase in CPU utilization over previous levels.

NOTE:Levels 9, 10 and 11 were deprecated in version 6.0 and are now automatically mapped to the new compression level 8.

Depending on your environment, the various algorithms will yield different results. When choosing a compression level, test various options to determine the best option for your environment. For more information, see Test Optimal Backup Settings.

Generally, the higher the compression ratio the higher the CPU utilization and potentially more compression. That is, the higher compression levels will look for longer patterns to compress, as well as perform more passes on the data.

The higher levels do not guarantee better compression ratios as the nature of the data dictates the final result. Therefore, some databases will get varying results as the level increases.

Additionally, if a higher level gets significantly better compression, it may actually perform faster than a lower level. Typically, the higher levels require more time for the backup.

NOTE: LiteSpeed supports backing up, restoring and shipping transaction logs of the databases encrypted with transparent data encryption (TDE). If you want to compress the backup, you should choose compression level 1 to minimize CPU, since using a higher level of compression will only cause CPU to increase without any real benefit on the backup file size. If you choose compression level 0, LiteSpeed will not attempt to compress the backup. Review the following for additional information:

  • Its important to back up the database encryption key, because there is no way to recover the data without the key. LiteSpeed does not automatically export the encryption key. If needed, you can include the encrypted key file in the backup. For more information, see Back Up Databases.
  • To further protect the backup, you can use LiteSpeed Encryption with TDE databases to add a secondary layer or protection to the backup. For more information, see Encryption Methods.

Adaptive Compression

With Adaptive Compression you do not have to run the Backup Analyzer wizard to determine the best compression level for a database. LiteSpeed will dynamically change the compression level during a backup in order to optimize for speed or size, while maximizing use of available CPU. If the server workload changes during the backup (change in CPU or Disk IO), Adaptive Compression automatically switches compression to maintain optimal performance.

You can select to optimize backups either for size or for speed:

  • Optimize for speed—Backups complete in the least amount of time possible. Available CPU is leveraged to reduce backup size, but not at the expense of increased backup time. This is the default setting.
  • Optimize for size—Backups are completed with higher compression while managing overall backup time to ensure backups do not take a long time to complete (when compared to optimizing for speed). In this mode, LiteSpeed allows the backup to complete more slowly if the reduction in speed results in a smaller backup file. This mode is designed for databases where a smaller backup is desired but managing how long the backup takes to complete is important as well.

NOTE: Adaptive Compression is only available with LiteSpeed 6.5 or later; Enterprise license.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating