Click here to monitor SSC
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-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: Administrators
Points: 35992 Visits: 18728
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
David.Poole
David.Poole
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3662 Visits: 3111
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

Newbie on www.simple-talk.com
TravisDBA
TravisDBA
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1462 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
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: Moderators
Points: 8424 Visits: 780
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 Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 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
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2666 Visits: 1694
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
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5766 Visits: 4704
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
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14369 Visits: 9729
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 (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 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
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14369 Visits: 9729
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