Re: [Veritas-bu] Fw: Data Domain Question
We're getting 94.29% savings on SQL backups with a different vendor. We have not tested backups with Data Domain although their product was strongly considered during our RFP process. -Original Message- From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of ccosta@gmail.com Sent: Tuesday, August 16, 2011 11:03 AM To: VERITAS-BU@mailman.eng.auburn.edu Subject: [Veritas-bu] Fw: Data Domain Question --Original Message-- To: VERITAS-BU@mailman.eng.auburn.edu Subject: Data Domain Question Sent: Aug 16, 2011 1:59 PM To all, I am interested in finding out what deduplication ratios users are seeing when backing native SQL dumps to a Data Domain array? Having friends who work for EMC, they say 3:1 to 4:1, but I am looking for real numbers that users are seeing not the sales numbers. Please let me know Sent via BlackBerry from T-Mobile ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Fw: Data Domain Question
In order to answer that question, another couple of questions would have to be asked: 1. How long are you going to retain these dumps? I am assuming that they are uncompressed. The longer you retain your backups, the better your deduplication ratio will be. We are wrapping up a proof of concept on a DD 860. At the end of our Open Systems (Windows/UNIX/Linux) part of the evaulation, we were getting 35:1 dedup ratio after 2 months. We were doing full backups every day. We were dumping database data (DB2 and SQL) directly to Netbackup via their respective agents. 2. How much does the database change between backups? You will have to talk to your DBAs and get this information. This may not be significant, but you need to find out before you purchase something that will be unable to deliver the results you expect. In my opinion, uncompressed database dumps are the best candidates for deduplication if your data only changes 10-20%. When I introduced the DB dumps to NBU to the DataDomain, my dedup ratios accelerated significantly. My 2 cents. From: ccosta@gmail.com To: VERITAS-BU@mailman.eng.auburn.edu Date: 08/16/2011 02:06 PM Subject: [Veritas-bu] Fw: Data Domain Question Sent by: veritas-bu-boun...@mailman.eng.auburn.edu --Original Message-- To: VERITAS-BU@mailman.eng.auburn.edu Subject: Data Domain Question Sent: Aug 16, 2011 1:59 PM To all, I am interested in finding out what deduplication ratios users are seeing when backing native SQL dumps to a Data Domain array? Having friends who work for EMC, they say 3:1 to 4:1, but I am looking for real numbers that users are seeing not the sales numbers. Please let me know Sent via BlackBerry from T-Mobile ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Fw: Data Domain Question
We have a retention period of 2 weeks on our SQL2008 environment which is dumping directly to our DD670. A quick check of our current stats show we are getting 34.02x compression on the contents of this directory. In theory compression will get better the longer you keep the data. We don't have a need for more than 2 weeks worth so that's all we keep. I can probably get some more specifics regarding the amount of data being backed up etc.. if that would help any further. Mark Glazerman Desk: 314-889-8282 Cell: 618-520-3401 please don't print this e-mail unless you really need to -Original Message- From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of ccosta@gmail.com Sent: Tuesday, August 16, 2011 1:03 PM To: VERITAS-BU@mailman.eng.auburn.edu Subject: [Veritas-bu] Fw: Data Domain Question --Original Message-- To: VERITAS-BU@mailman.eng.auburn.edu Subject: Data Domain Question Sent: Aug 16, 2011 1:59 PM To all, I am interested in finding out what deduplication ratios users are seeing when backing native SQL dumps to a Data Domain array? Having friends who work for EMC, they say 3:1 to 4:1, but I am looking for real numbers that users are seeing not the sales numbers. Please let me know Sent via BlackBerry from T-Mobile ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Fw: Data Domain Question
I can't answer your question either, but there should be a lot of it depends in any answer. - many dedup appliances will not only dedup but will do traditional compression. Compress your SQL dump with your favorite compression utility. Your dedup appliance is unlikely to do better at compression. - If you run your SQL dump a bazillion times, you'll see an incredible dedup ratio. All this means is that if it's important to backup the same thing over and over, your dedup appliance will do a nice job. Many stupid backup programs will backup the same thing over and over. They can't help it; they were brought up that way. - If you make a SQL dump of many different database objects, your dedup appliance will or may find identical blocks within the dumps, allowing you to store the dumps using less appliance space. The dedup you get from these sorts of storage may or will increase somewhat as you fill your appliance with various stuff. - Even within one SQL dump, your dedup appliance will or may find identical blocks, allowing you to store the dump using less appliance space. - A dedup ratio of 3-1 or 4-1 would make for extremely expensive storage on a dedup appliance. - If you're really considering an appliance, have the VAR/vendor prove their claims --- on your data. - Consider: if you procure an appliance/solution, is there a method to test the dedup ratio of some of your data? That is, will you be able to tell the ratio due to your SQL dump of a different/new database object? Sorry I can't answer your question! Cheers, Wayne There is no job so simple that it cannot be done wrong. (Perrussel's Law) On Tue, Aug 16, 2011 at 2:02 PM, ccosta@gmail.com wrote: --Original Message-- To: VERITAS-BU@mailman.eng.auburn.edu Subject: Data Domain Question Sent: Aug 16, 2011 1:59 PM To all, I am interested in finding out what deduplication ratios users are seeing when backing native SQL dumps to a Data Domain array? Having friends who work for EMC, they say 3:1 to 4:1, but I am looking for real numbers that users are seeing not the sales numbers. Please let me know Sent via BlackBerry from T-Mobile ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu