Our DB admin mentioned it might be a good idea to consider using data compression on our SQL Server DBs. The recommendation is of course contingent on NAM supporting this. He
referenced an article which states that performance can improve and data size can be
reduced by using data compression to reduce the amount of IO going to and from
the disk. There is a slight increase in CPU to handle this but our systems have
pretty light CPU so it might be worth looking into for some of the large
Solved! Go to Solution.
We do not recommend or support it, as we have not tested it. More information is available in this thread:
edit: I stand corrected, and my information applies only to 2018 GA and earlier; its support is still contingent on the SQL version supporting it
Actually we do support it since 2018 SP1. Whether it is working out of the box or not depends on the SQL Server version you have. If you have 2016 SP1 or later it should be working by default. If you have Enterprise Edition older than 2016 SP 1 then you should set this general property to true to enable it.