THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Lara Rubbelke

Interesting Things in the World of SQL Server

Should I Compress My Indexes? New Compression Whitepaper!

A very well written study of the compression is now available: Data Compression - Strategy, Capacity Planning and Best Practices.  This study provides guidance on best practices for designing, implementing and managing compression in your environment.  I found this whitepaper to be full of useful guidance and scripts to monitor and manage compressed tables. 

The paper starts with tips and tools to help decide what to compress.  It then guides the reader through considerations for implementing compression and estimating necessary resources to complete compression.  The final sections of the paper provide guidance and evidence on management topics – space management, performance management, partition management. 

I am certain that those who are considering compression will find these concepts, scripts and tools to support the full lifecycle of compression.  I know that I will keep this on my short list of favorite whitepapers!

Published Sunday, May 31, 2009 11:27 AM by Lara Rubbelke

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement