SQL Server 2012 Page Compression - Determine compression ratio? We're using SQL Server 2012 and have page compression turned on for a number of our larger tables. Is there a way we can determine the compression ratio we're getting? We'd like to be able to determine the benefits of compression.
How about sp_estimate_data_compression_savings?

It allows you to estimate the gain from compression BEFORE you compress the table, but it's quite accurate.