We experienced the same thing in our testing. The more redundancy you have the better de-dup works :)
As soon as you compress your dumps you are not going to be able to de-dup as well as uncompressed data. I have yet to see a de-dup product that is cost effective with compressed files. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Nancy L Leugemors Sent: Thursday, August 26, 2010 12:23 PM To: ADSM-L@VM.MARIST.EDU Subject: Data Domain: Data Domain, and SQL-Backtrack with Sybase databases Hello, I'm looking for anyone who is using SQL-Backtrack for Sybase and Data Domain/TSM? We are replacing our Virtual Tape libraries and physical tape library with Data Domains. One here onsite and another at our DR location. We have setup the Data Domain to emulate VTL. We are experiencing poor deduplication rates on our SQL-Backtrack Sybase compressed databases only. We see a 1:1:1 dedup ratio on Sybase data backed up with Backtrack. When the data is not compressed, we see dedup ratios anywhere from 5:1 to 150:1 on some tapes. Obviously, as you add backup versions of the same DB on DataDomain, each new version gets better dedup because a lot of common blocks are already on the appliance. But, of course then the backup runs 2x as long which is not acceptable for our RPO. Our DB2-UDB,MS-SQL,and Domino TDP all are seeing much better dedup rates. Background: TSM Server Version: 5.5.4.0 TSM Client: 5.5.2.0 TSM Client Sybase Version: ASE 15.0.3 TSM Client SQL-Backtrack Version: 6.8 Data Domain: Model: 880 Data Domain OS Version: 4.8.1.0 Nancy Leugemors Enterprise Systems HealthNow, NY 716-887-7979 CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please contact the sender by reply email and destroy all copies of the original message.
