SQL SERVER – SQL Server Compression Estimator

I recently come across an interesting tool called ‘SQL Server Compression Estimator’. I find this tool very interesting. This tool is a pretty decent tool and I used it on a couple of my personal server and it gave me a good estimate.

SQL Server Compression Estimator (SSCE) will allow you to estimate the best compression for your objects. It will estimate both ROW and PAGE compression, and will optionally report the Index Maintenance Ratio.

SQL SERVER - SQL Server Compression Estimator compesti

You can order the resultset based on compressed Size or % Saving. Based on the estimate you can check the checkbox in the last column. Clicking on Generate Script will generate T-SQL script to compress your object (Index, Table).

SQL SERVER - SQL Server Compression Estimator codeplex-800x200

Just like every other tool, you have to use it carefully and use your own judgment on a production server. However, I find this tool as a good start on this subject. Thanks to Bob Taylor who has created this tool. He has blogged about this tool over here.

Reference : Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Attending MVP Open Day – May 2011
Next Post
SQLAuthority News – Facebook Page and Twitter – Connect Using Social Media

Related Posts

1 Comment. Leave new

  • Kevin Edward Kline
    June 14, 2011 9:32 pm

    Great minds think alike! I just did a review of this tool as well for my SQLMag column. :^) It’s really neat!

    Best regards,

    -Kev
    Twitter @kekline

    Reply

Leave a Reply

Menu