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.
Answer by Przemyslaw T. ·
Hi, a quick update on this. NAM Server SQL database compression is one of the built-in features in the upcoming NAM 2019 release, which is now in BETA stage. See what else is coming in NAM 2019 and if you're interested in sing-up for BETA to give it a try now.
Answer by Robert G. ·
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.