SQL Server Compression Estimator tool
Bob finally released the SQL Server Compression Estimator tool to http://ssce.codeplex.com/
SQL Server Compression Estimator (SSCE) will allow you to estimate the best compression for your objects. It will estimate both ROW and PAGE compression for all objects, and will optionally report the Index Maintenance Ratio (a ratio that indicates how often an index is updated versus how often it is used to satisfy queries). You can then use that information to perhaps choose a less aggressive compression algorithm for heavily updated indexes.
For more information on the benefits of data compression please visit the SQL Customer Advisory Team site and view some in depth information regarding data compression
- Data Compression: Strategy, Capacity Planning and Best Practices - http://sqlcat.com/top10lists/archive/2009/01/30/top-10-sql-server-2008-features-for-the-database-administrator-dba.aspx
- Top 10 SQL Server 2008 Features for the Database Administrator (DBA) - http://sqlcat.com/top10lists/archive/2009/01/30/top-10-sql-server-2008-features-for-the-database-administrator-dba.aspx