I've been asked if enabling SQL Server compression on CAS/ADS databases is supported. I can only think of one possible problem, is that the CAS/ADS repeatedly refresh their tables daily, which would mean any compression attributes would be lost as the tables are recreated - unless the CAS/ADS has a configuration option to enable to ensure the tables are re-created with the attribute set.
Solved! Go to Solution.
It depends on which tables would you like to compress. Some of them are recreated, some truncated and some maintained by a simple delete statement.
I see one more concern. The compression feature is only available for non-standard SQL server editions and it has not been tested. If compression attribute remains for the table after 97 days this table will be reused for inserting. My concern is the impact of the compression on the data inserting.
Thanks Robert, customers DBA is asking if it can be enabled or not, they intend to have it on 'live' tables. Apparently there is plenty of spare CPU cycles, and the end game is to reduce the usage of their SSD storage.