For the production DB, there would be no data reduction benefit.  In the case of snapshots however, you would have a full initial dedupe. A 1TB database with many snapshots would still be just 1TB of physical capacity used. However, new writes to any of these copies would not deduped.  Hope this helps!  -Bryan
Hello,  With a general de-duplication ratio of about 2:1 with XtremIO and SQL, does this decrease and become closer to 1:1 if native encryption is utilized with SQL Server? I have a customer that has asked about any effects of using native SQL replication with an XtremIO array and what that does to the data profile being de-duped/compressed on the array side.   Thanks!
Effect of SQL Native Encryption on deduplication ration