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.
Sql-server – SQL Server 2012 Page Compression – Determine compression ratio
compressionsql serversql-server-2012
Related Question
- Sql-server – XML Network Call to Application from SQL Server 2005
- Sql-server – Page compression not working
- Sql-server – GZipStream/DeflateStream compressions alternatives
- Sql-server – SQL Prove memory pressure – high Buffer Cache Hit Ratio, but low Page Life Expectancy
- Sql-server – Use of table compression in SQL Server 2014
- Sql-server – the row overhead when using Page Compression
- Sql-server – SQL Server 2012 compress column for whole table
Best Answer
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.