More Information About Tuning Backup Compression

Sanjay Mishra and Mike Ruthruff from Microsoft’s SQLCAT team have published Part Two of their Technical Note about how to tune SQL Server 2008 Backup Compression for maximum performance. The main two things that you can adjust are the BUFFERCOUNT and MAXTRANSFERSIZE settings, which can be changed to help improve backup performance.

They also investigate the interactions between data compression and backup compression, and how transparent data encryption (TDE) affects backup compression (hint: it is not in a good way). I was one of the many technical reviewers for the article.

Technorati Tags:

This entry was posted in SQL Server 2008. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s