SQL Server Compression Estimator (SSCE) Released on CodePlex

One of the most exciting additions to SQL Server 2008 was the capability to apply data compression. The benefits are many including reduced disk I/O and memory utilization, with a small cost of CPU overhead.In a database that may contain thousands of objects, determining which objects and / or partitions of those objects may benefit […]

One of the most exciting additions to SQL Server 2008 was the capability to apply data compression. The benefits are many including reduced disk I/O and memory utilization, with a small cost of CPU overhead.

In a database that may contain thousands of objects, determining which objects and / or partitions of those objects may benefit from data compression can be time consuming and labor intensive.

Not anymore! SQL Server Compression Estimator (SSCE) released on CodePlex, that will "allow you to estimate the best compression for your objects," informed Bob Taylor.

"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," stated Taylor.

Download SSCE From: CodePlex

[Source: OpsVault]

About The Author

Deepak Gupta is a IT & Web Consultant. He is the founder and CEO of diTii.com & DIT Technologies, where he's engaged in providing Technology Consultancy, Design and Development of Desktop, Web and Mobile applications using various tools and softwares. Sign-up for the Email for daily updates. Google+ Profile.