April 21, 2008 at 10:28 am
I'm looking to make the case for a compression based backup tool for SQL server. Pretty much a toss up between Idera and Redgate. 🙂
Part of making the case though is going to be costs and cost savings. Does anybody know of a link to a good article that lists the administrative costs per Gigabyte per year?
I've been googling my heart out, but I haven't been able to hit a $ figure I can use to calculate what the ROI would be to implement either product on as many as 30-50 SQL servers handing approx 3-5 TB of data.
Idera estimates via their tool at $200/GB/Year which seems high to me, but I don't have anything to compare to.
April 21, 2008 at 2:18 pm
Can't help you with an ROI, but I'd also look at HyperBac from HyperBac. It was selected as the Editors Choice in the latest version of SQL Server magazine (which is where I first heard about it).
😎
April 21, 2008 at 9:49 pm
You don't need admin costs, you need savings based on GB. It's the cost of your GB per year in media, people, time, etc.
The compression rates for Litespeed/SQL Backup/Hyperbac are all similar. All good products. When I made the case, it was running the trial on 4-5 servers, estimating then the total savings in backups, then go to savings in time and media. Get cost of your media, and consider how far this pushes out the need for purchasing a larger backup system.
At JDEdwards we diff's about 1TB a day across all servers (file, Exchange, SQL) onto the backup system. About 250GB or so was SQL Server. With compression, we ran that down to about 100GB, so a substantial savings. Multiply out the disk/tape cost and you're getting a payback in about a year. At least at that time.
Admin cost is similar as it still takes the same amount of time to check if the backup ran. Restores are quicker.
April 22, 2008 at 8:11 am
Steve Jones - Editor (4/21/2008)
You don't need admin costs, you need savings based on GB. It's the cost of your GB per year in media, people, time, etc.
That's actually exactly what I meant by Administrative costs... the costs to administer the system in terms of people, their time, etc... truthfully the actual costs of storage are all but meaningless these days when I can get a 1 TB SATA drive for about $300 ~$.30/GB 🙂
Around here (my office) it's hard to get a metric for anything, so I was hoping to find some established industry averages.
April 22, 2008 at 8:27 am
It's hard to know what an average is. Big disks are cheap, but putting disks into a SAN, running SCSI-x is more expensive, moving to RAID, etc. It adds up. You'd be surprised how much cost there is. Especially if you extrapolate growth out and think about the next time you need to "add" disk to your server. It's not as easy as running to CompUSA and grabbing a $300 1TB disk.
Also think tape. Our large tapes in 2001/2002 were nearly $100 apiece. Add that up over the number you need in rotation and it's starting to be a good cost.
Also, depending on # of instances, you can negotiate some good deals with vendors, so I'd also see how much of a discount you can get.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply