Where we were - Test and Prod environments onSQL Server 2012 using database compression and spindle storage.
We moved to Pure Storage earlier this year and left the SQL compression on since we didn't have the storage space or a third server to see how long it will take to change over to hardware compression, how much space it would lose or gain and we were waiting for the first service pack for sql 2016.
Now we are getting a third DEV environment, and the non technical people are trying to figure out whether to enable hardware compression or use SQL compression. So I am hoping that someone here has some history with SQL server 2016 and flash storage and which compression performed better.
Our VLDW contains a few terabyte of data from EMR systems used to populate QlikView applications and SSAS tabular models.