HDD RAID TCO Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Drive Unit CostDrive CapacityCost / TBQtyActual CostArray Capacity (TB)RAID Cost/TBPower / Drive (W)kWh / yrkWh Cost / yrkWh Cost / lifeTCOTCO/TBControllers NeededController CostAddt'l CostAddt'l kWh / yrAddt'l kWh Cost / yrAddt'l kWh Cost / lifeFinal TCOFinal TCO / TBTotal Capital Cost ($ Needed Now)
2
$80.003$26.6733$2,640.0081$32.5961734.48$433.62$2,168.10$4,808.10$59.363$225.00$330.00867.24$216.81$1,084.05$6,447.15$79.59$3,195.00
3
$110.004$27.5024$2,640.0080$33.0061261.44$315.36$1,576.80$4,216.80$52.712$150.00$240.00630.72$157.68$788.40$5,395.20$67.44$3,030.00
4
$170.006$28.3315$2,550.0066$38.646788.4$197.10$985.50$3,535.50$53.572$150.00$150.00394.2$98.55$492.75$4,328.25$65.58$2,850.00
5
$225.008$28.1312$2,700.0080$33.756630.72$157.68$788.40$3,488.40$43.611$75.00$120.00315.36$78.84$394.20$4,077.60$50.97$2,895.00
6
$290.0010$29.009$2,610.0070$37.296473.04$118.26$591.30$3,201.30$45.731$75.00$90.00236.52$59.13$295.65$3,661.95$52.31$2,775.00
7
$375.0012$31.257$2,625.0060$43.756367.92$91.98$459.90$3,084.90$51.421$75.00$70.00183.96$45.99$229.95$3,459.85$57.66$2,770.00
8
$500.0014$35.715$2,500.0042$59.526262.8$65.70$328.50$2,828.50$67.351$75.00$50.00131.4$32.85$164.25$3,117.75$74.23$2,625.00
9
10
Appx max Budget:
$2,700.00
The most you can spend right now on your drives (excluding controllers, etc.)
11
Parity Drives:
2
Parity drives: 2=RAID6 or RAIDZ2, 3=RAIDZ3. (This won't calculate mirroring properly nor should you use RAID5, so don't use 1.)
12
Max drives per stripe:
12
Max drives per stripe (between 8 and 12 is a good number).
13
Power Cost/kWh:
$0.25
Make sure this is accurate for your area. Power charges vary widely.*
14
Assumed drive life (yr):
5
Feel free to change this, but it must make real-world sense.
15
Drives / Controller:
12
This is an average-ish controller capacity. If you're gonna use just on-motherboard ports, it's irrelevant because...
16
Controller Cost:
$75.00
Cost per SATA / SAS controller. If you're gonna use just on-motherboard ports, make this zero.
17
Addt'l Per Drive Cost:
$10.00
The added one-time cost of a bigger PSU, case, more MB slots, cabling, etc.
18
Addt'l Per Drive Watts:
3
The added power required for drive controllers, PSU inefficiency, more cooling fans, etc.
19
20
Notes:
21
This sheet is all based upon your max budget. Set F10 first.
Generally speaking, as your budget gets higher (and therefore the quantity of drives that
22
All numbers in a black font are read-only.
you can use in your array increases), the better TCO values will
23
Fields with a blue background are those you definitely want to change to suit your needs/costs
trend towards bigger capacity drives. This is due to the lower relative cost of parity
24
Fields with a purple background are those you probably want to change, or at least verify
overhead.
25
Array capacity is marked with a yellow background because it's obviously super important. (But read-only.)
Likewise, a lower budget will probably dictate using smaller capacity drives.
26
When making this sheet I went in with the budget as the priority, but of course
(Of course, the whole point of this spreadsheet is because those general
27
you may have a certain amount of storage need, and that may supercede your
statements may not be true for your use case.)
28
budget requirements. You can tweak the budget until you get a capacity which
29
suits your needs, or even re-work the sheet to make the capacity the driving number.
IF YOU GET #DIV/0 ERRORS IN SOME ROWS FOR TCO,
30
I used HDD costs based upon when I created the spreadsheet and the drives I wanted to use.
THAT'S PROBABLY BECAUSE YOUR BUDGET IS TOO SMALL
31
You should check drive prices right now, because that will make a huge difference.
FOR THE NUMBER OF PARITY DRIVES YOU SELECTED
32
* Cost/kWh may not be as simple as the cost per kWh listed on your power bill.
FOR THE CAPACITIES THAT HAVE THOSE ERRORS.
33
For example, my power company levies a seperate "delivery charge" to
You can ignore those errors and just resign yourself to the fact that those drive capacities
34
cover infrastructure costs, which is based upon usage.
don't make sense for anything except mirroring.. at best.
35
The "addt'l" costs (fields F16 and F17) are something you're going to have to estimate.
36
If you don't feel like getting involved in that, TCO/TB (column M) should
37
give you reasonably good guidance.
38
Power / Drive is something you'll have to glean from the manufacturer data sheets
39
for the drive(s) you're going to use. The 6W used as a default is probably
40
a reasonable number for 5400RPM drives with a lower workload.
41
Most importantly, play with the numbers.
42
That will give you a better feel for how each aspect of your proposed
43
setup impacts the TCO.
44
HOWEVER!
45
Remember that this isn't going to be 100% accurate. Small changes in multiple fields
46
can really impact the TCO. Unforseen things like environmental factors could
47
also have an effect. (E.g. more drives means more air condidtioning in hot climates.)
48
This sheet is simply for guidance, but you may be surprised at the TCO numbers.
49
Very often the largest drives make for the least efficient configurations,
50
but not always.
51
FINALLY, you might of course have your own priorities. E.g. more drives means more
52
noise, which you might find an overriding factor to cost. Same goes for
53
space, because obviously a few large capacity drives can be put in a smaller
54
case. But these numbers may serve to put your priorities in perspective.
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu