sdpaiva

Compression Rates for SQL Server

Discussion created by sdpaiva Employee on Apr 9, 2013
Latest reply on Apr 23, 2013 by Ben Watson

Nimble Storage offers inline variable-block compression that can save you lots of disk space without compromising performance.  You may be wondering just how much savings you can expect with Nimble’s compression, and if you’re curious about compression rates for SQL Server, you’ve come to the right place!

 

The graph below, generated by Nimble Storage's InfoSight deep-data analytics service, shows real compression rates across the Nimble Storage install base (taken on April 4th 2013) for volumes using the SQL Server performance policies.

SQL server compression.JPG.jpg

 

 

As you can see, the average compression for SQL Server database comes in at just over 2.0, and for SQL Server Logs, compression is even higher at 2.2! Nimble Storage’s compression is on average very effective at compressing the data stored by SQL Server, and results in a huge reduction in storage space requirements.

 

With Nimble Storage, not only do you save space on your volumes, but your pointer based thin (block level incremental) snapshots also benefit from compression.


How do these compression rates compare with what you are seeing across your applications?

Outcomes