SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Cost of Storage


The Cost of Storage

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)SSC Guru (139K reputation)

Group: Administrators
Points: 139365 Visits: 19412
Comments posted to this topic are about the item The Cost of Storage

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Dave Poole
Dave Poole
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16096 Visits: 3403
Very much so.

The cost of storage influences the following:-
  • Design of the solutions

  • Retention strategies for data

  • The disaster recovery strategy

  • What goes on what grade storage

  • Timescales for development i.e. lead team for the purchase decision and commissioning of storage



LinkedIn Profile
www.simple-talk.com
TravisDBA
TravisDBA
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3240 Visits: 3069
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

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
Antares686
Antares686
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: Moderators
Points: 25420 Visits: 785
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.



cdonlan 18448
cdonlan 18448
SSC Journeyman
SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)SSC Journeyman (95 reputation)

Group: General Forum Members
Points: 95 Visits: 283
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.
Miles Neale
Miles Neale
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4180 Visits: 1695
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.

Not all gray hairs are Dinosaurs!
Revenant
Revenant
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12149 Visits: 5010
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."
GSquared
GSquared
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54459 Visits: 9730
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.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
david.ashby
david.ashby
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 48
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.
GSquared
GSquared
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54459 Visits: 9730
david.ashby (11/16/2012)
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.


(emphasis added) Only from people who are really intent on displaying their ignorance. :-P

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search