Currently due to performance concerns that were present when we moved our SQL Servers to our Nimble CS-220 we were under instructions not to implement compression on the datastores that hold our SQL databases but we are seeing a general compression ratio of about 1.4 with great performance overall, considering a less than optimal networking environment (soon to be corrected) that it is working in. So far, I've been pretty impressed with the performance of the unit overall for the functions it is performing.
thanks for sharing your experience Will.
it's possible there was some mis-communication during your initial installation, but there is no reason to disable compression on SQL volumes. In fact, the built in SQL performance policies that ship with the system have compression enabled by default. We have a large number of systems in production enjoying both great performance and good compression rates for SQL volumes. If you have any concerns, please contact support and they can guide you through the process of enabling compression.
We have a customer who's seeing 3.75:1 compression ratio on a subset of their SQL volumes. It's not a global average, but interesting to see such impressive compression figures (considering the only other compression options would see either performance degradation or extensive work required to mitigate the performance decrease).