LiteSpeed: analysis of compression and efficiency

by Andy Grant

I read a post recently on The Grateful DBA that describes his analysis in testing different compression levels in LiteSpeed for SQL Server and their impact on both backup size and efficiency. In his own words this is a "non-scientific, ground-level look at LiteSpeed's compression ratios", but I think this approach is a real world approach. The post describes the pros and cons of higher vs. lower compression levels and where each is appropriate depending on the database environment. There's good food for thought in the blog entry and there's a pretty graph! for thought and pretty graph....

Anyway, again, I just wanted to repost the blog entry and invite discussion. Here's the link again: - thank you Grateful DBA.

Have a great weekend everybody and good luck getting your last minute Christmas shopping out of the way.