SQLServerCentral / Editorials / SQLServerCentral.com / The Cost of Storage / Latest Posts

RE: The Cost of Storage

David.Poole — Sun, 18 Nov 2012 10:03:02 GMT

[quote][b]Revenant (11/16/2012)[/b][hr]I agree, but numbers that David quotes are at least 10 times higher than what I hear from our ops.[/quote]Our ops guys flex the quote depending on the IO/throughput/access profile.Storage volume is cheap, storage performance/concurrency isn't.I'm waiting to see what happens to those people with 4TB drives in their Hadoop clusters once they start getting a few people battering them via HIVE or comparable technology.

RE: The Cost of Storage

jay-h — Fri, 16 Nov 2012 13:33:33 GMT

There was a case in the news a while back where a doctor was charged with misuse of prescriptions. However since he had fled the country and was not expected back, the prosecutor actually dropped charges so that the large amount of storage in his case could be deleted because it was becoming to expensive to keep it. I found that a bit astonishing.

RE: The Cost of Storage

Revenant — Fri, 16 Nov 2012 12:38:21 GMT

[quote][b]GSquared (11/16/2012)[/b][hr][quote][b]david.ashby (11/16/2012)[/b][hr]Cost for cheap SAN storage where I work is £3,000 per TB ($4,500 USD) and £10,000 per TB ($16,000 USD) for the 5 year TCO. As you can imagine every request is heavily scrutinised, tape backups have to be justified etc.If we had SSD's it would be £50,000 per TB. This is in a EMC SAN array. All production disks are mirrored locally and remotely to the other data centre. So if you ask for 1TB in production storage needs to supply 4TB. So the price jumps to £40,000 per TB.[b]How many time have I heard but I can go to the local PC shop and buy a TB for £100[/b].[/quote](emphasis added) Only from people who are really intent on displaying their ignorance. :-P[/quote]I agree, but numbers that David quotes are at least 10 times higher than what I hear from our ops.

RE: The Cost of Storage

GSquared — Fri, 16 Nov 2012 12:32:19 GMT

[quote][b]david.ashby (11/16/2012)[/b][hr]Cost for cheap SAN storage where I work is £3,000 per TB ($4,500 USD) and £10,000 per TB ($16,000 USD) for the 5 year TCO. As you can imagine every request is heavily scrutinised, tape backups have to be justified etc.If we had SSD's it would be £50,000 per TB. This is in a EMC SAN array. All production disks are mirrored locally and remotely to the other data centre. So if you ask for 1TB in production storage needs to supply 4TB. So the price jumps to £40,000 per TB.[b]How many time have I heard but I can go to the local PC shop and buy a TB for £100[/b].[/quote](emphasis added) Only from people who are really intent on displaying their ignorance. :-P

RE: The Cost of Storage

david.ashby — Fri, 16 Nov 2012 12:15:36 GMT

Cost for cheap SAN storage where I work is £3,000 per TB ($4,500 USD) and £10,000 per TB ($16,000 USD) for the 5 year TCO. As you can imagine every request is heavily scrutinised, tape backups have to be justified etc.If we had SSD's it would be £50,000 per TB. This is in a EMC SAN array. All production disks are mirrored locally and remotely to the other data centre. So if you ask for 1TB in production storage needs to supply 4TB. So the price jumps to £40,000 per TB.How many time have I heard but I can go to the local PC shop and buy a TB for £100.

RE: The Cost of Storage

GSquared — Fri, 16 Nov 2012 11:49:45 GMT

Total cost of storage is a complex evaluation. Trying to calculate return-on-investment with it is virtually impossible, too. Far too many variables.Despite that, I know what the dollar cost of our database storage is. But only because we use a hosting service for the servers, and the cost of storage is a monthly billable. Cost to them? No clue. Cost to us? I can get a copy of the exact invoice for any month in the last however many years. Cost of adding more? Easy, since I have quotes from them on it.RoI on the storage? No real way to know.

RE: The Cost of Storage

Revenant — Fri, 16 Nov 2012 10:22:01 GMT

I am dealing with hundreds of TB but storage cost is unimportant compared to the dev and QA costs. My marching orders are "burn any storage and CPU cycles if it helps bring the dev costs down."

RE: The Cost of Storage

Miles Neale — Fri, 16 Nov 2012 09:31:40 GMT

The cost of not having the amount of data and saving a few dollars in the short run is far more costly than spending the dollars to understand the business better. The total cost of data for us is growing due to better systems and a better understanding of data. If you look only at the databases the growth is significant. However, if you look at the amount of noSQL data in documents and spreadsheets across the business it is massive. The cost of data is very high and growing, but the demand for information from that data is critical to any business. Can you imagine the company who projects their product line on the business in the last weeks trend and not the other important periods of time. By identifying the needed time spans and evaluating the trends within those time periods can be the most important thing a business does short of producing the primary product. M.

RE: The Cost of Storage

cdonlan 18448 — Fri, 16 Nov 2012 08:14:10 GMT

I can't remember the last time I had a battle over storage costs. In discussions about controlling storage growth, I'm usually trying to convince people to either let go of some data or allow it to be organized in a prioritized, noise filtering fashion. In larger IT shops this is a much easier sale, smaller shops... not so much.

RE: The Cost of Storage

Antares686 — Fri, 16 Nov 2012 07:18:37 GMT

Right off I don't recall, but when working under a project we get all the figures for this. Yes cost for the storage size itself goes down but there is the cost of power consumption, physical space, non-disk hardware infrastructure (including cool systems such as large AC units and rack), software licenses, and support personel, plus your DR infrastructure that often are overlooked as a user I may not pay directly for them, but the corporation I work for sure does and there are people who track these things to make sure things are consolidated where and as much as possible.

RE: The Cost of Storage

TravisDBA — Fri, 16 Nov 2012 07:12:34 GMT

Actually, the cost of disk storage over the last 10 years has seen a pretty straight decline in the cost of hard disk drives. A Terabyte or two isn't all that expensive anymore.:-D

RE: The Cost of Storage

David.Poole — Fri, 16 Nov 2012 01:24:58 GMT

Very much so.The cost of storage influences the following:-[ul][li]Design of the solutions[/li][li]Retention strategies for data[/li][li]The disaster recovery strategy[/li][li]What goes on what grade storage[/li][li]Timescales for development i.e. lead team for the purchase decision and commissioning of storage[/li][/ul]

The Cost of Storage

Steve Jones - SSC Editor — Thu, 15 Nov 2012 22:10:34 GMT

Comments posted to this topic are about the item [B]The Cost of Storage[/B]