Checking the Compression Ratio

The compression ratio represents the ratio of compressed block size (including overhead) to expanded block size, regardless of the compression method in effect (bitmap or RLE). The larger the number, the more compression.

Note:

This statistic does not apply to aggregate storage databases.

  To check the compression ratio for a database:

  1. From Enterprise View or a custom view, select a database.

  2. Right-click and select Edit, then Properties.

  3. In the Database Properties window, select the Statistics tab.

  4. Expand the Blocks node and find Compression ratio in the list.

Related Information

Related Commands