Raid and IOPs Cheat Sheet – Excel

I made this 5 years ago in Excel and it was pretty popular. I think there are some errors in the math formulas that were pointed out for RAW calculations of backend IOPs. So use with caution, but mostly it should give a good enough idea on whatever it is you might be doing.

If you make modifications, please drop me a line in the comments or get in touch with me. I’ll update my post to include fixes.

RAID-and-IOPS Cheat Sheet Download

RAID, IOPS, MBps and more Excel Cheat Sheet

I’m working on an Excel spreadsheet (cheatsheet) that will allow for user input to calculate some of the following:

  • Calculate IOPS, Usable Space, MB/s  based on Number of Disks, Spindle Speed, RAID type and Read/Write Percentages.
  • Calculate Number of Disks required for IOPs
  • Calculate/Convert MB/s to IOPS
  • Calculate/Convert IOPS to MB/s

It also contains some basic information and formulas:

  • Formula for Total Raw IOPS
  • Formula for Functional IOPS
  • Formula for MB/s from IOPS
  • Formula for IOPS from MB/s
  • Formula to determine number disks required for IOPs based on RAID type and spindle speed.

Here’s a screenshot:

RAID/IOPS Calculator Cheat Sheet

RAID/IOPS Calculator Cheat Sheet

Here are some of the formulas used:

  • Total Raw IOPS = Disk Speed IOPS * Number of Disks
  • Functional IOPS = (((Total Raw IOPS*Write%))/(RAID Penalty))+(Total Raw IOPS*Read%)
  • MB/s = (IOPS * KB per IO) / 1024
  • IOPS=(MBps Throughput / KB per IO) * 1024
  • Formula to determine disks required for IOPs (total required IOPS * read%) + (total required IOPS * write% * RAID penalty) = total IOPS required take that and divide by IOPS provided by disk type (15k=175, 10k=125, etc.)

Download the Spreadsheet (XLSX):  Download

RAID, IOPS, MBps and more Excel Cheat Sheet

[stextbox id=alert]Hi Everyone!  I have taken the XLS file offline.  There were a ton of bugs, as pointed out in comments and through emails/Twitter.  I am working on solidifying the functions and migrating this to an actual application instead of Excel.   In the meantime, you can check out other calculators here.[/stextbox]

Updated:  I am going to take this offline for awhile.  I really need to sit back down and go over what I had intended this to be used for since I’m starting to mix all types of things on this sheet and my terminology I’m sure does not match correctly with what I’m trying to express in the sheet.  I’ll repost the download when I have had time to review.

Updated:  You can download the Excel workbook RAID-and-IOPS which has updates/bugfixes through December 3, 2012 as noted in comments below.

I’m working on an Excel spreadsheet (cheatsheet) that will allow for user input to calculate some of the following:

  • Calculate IOPS, Usable Space, MB/s  based on Number of Disks, Spindle Speed, RAID type and Read/Write Percentages.
  • Calculate Number of Disks required for IOPs
  • Calculate/Convert MB/s to IOPS
  • Calculate/Convert IOPS to MB/s

It also contains some basic information and formulas:

  • Formula for Total Raw IOPS
  • Formula for Functional IOPS
  • Formula for MB/s from IOPS
  • Formula for IOPS from MB/s
  • Formula to determine number disks required for IOPs based on RAID type and spindle speed.

Here’s a screenshot:

RAID/IOPS Calculator Cheat Sheet

Here are some of the formulas used:

  • Total Raw IOPS = Disk Speed IOPS * Number of Disks
  • Functional IOPS = (((Total Raw IOPS*Write%))/(RAID Penalty))+(Total Raw IOPS*Read%)
  • MB/s = (IOPS * KB per IO) / 1024
  • IOPS=(MBps Throughput / KB per IO) * 1024
  • Formula to determine disks required for IOPs (total required IOPS * read%) + (total required IOPS * write% * RAID penalty) = total IOPS required take that and divide by IOPS provided by disk type (15k=175, 10k=125, etc.)

 

IOPs Calculator and RAID Calculators / Estimators

This page contains RAID calculators, IOPS calculators and other estimatior tools to use for raid disks and disk arrays.  If you know of other calculators, please leave a comment and I’ll list it here.  Thanks!

Update:  I have an Excel workbook cheat sheet that I use to do quick calculation

RAID, IOPS, MBps Excel Cheat Sheet

Link:   https://techish.net/technology/hardware/raid-iops-mbps-and-more-excel-cheat-sheet/

width=1394

RAID/IOPS Excel Cheat Sheet

Great resource for calculating IOPs from a given RAID configuration and also calculating needed disks for average IOPs.

wmarow’s iops calculator

Link:  http://wmarow.com/storage/strcalc.html

width=747

wmarow’s iops calculator

 

iBeast Basic RAID disk space utilization calculator

Link:  http://www.ibeast.com/content/tools/RaidCalc/RaidCalc.asp

width=297

iBeast RaidCalc

 

 

 

 

 

 

 

 

 

 

WolframAlpha’s Raid Calculator: (Who doesn’t love Wolfram!?)

Link:  http://www.wolframalpha.com/input/?i=RAID+calculator

width=599

WolframAlpha’s Raid Calculator

eprich: Estimate Storage Backend IOPs

Link: http://www.eprich.com/tools/simple-raid-group-calculator

width=334

eprich storage backend IOPs estimator

IOPS Calculator and RAID Calculators / Estimators

This page contains RAID calculators, IOPS calculators and other estimatior tools to use for raid disks and disk arrays.  If you know of other calculators, please leave a comment and I’ll list it here.  Thanks!

Update:  I have an Excel workbook “cheat sheet” that I use to do quick calculation

RAID, IOPS, MBps Excel Cheat Sheet

2014-05-27_181649

Link:   https://techish.net/technology/hardware/raid-iops-mbps-and-more-excel-cheat-sheet/
Great resource for calculating IOPs from a given RAID configuration and also calculating needed disks for average IOPs.

wmarow’s iops calculator

Link:  http://wmarow.com/storage/strcalc.html

2014-07-18_172850

iBeast Basic RAID disk space utilization calculator

Link:  http://www.ibeast.com/content/tools/RaidCalc/RaidCalc.asp

2014-07-18_172935

WolframAlpha’s Raid Calculator: (Who doesn’t love Wolfram!?)

Link:  http://www.wolframalpha.com/input/?i=RAID+calculator

2014-07-18_173041

eprich: Estimate Storage Backend IOPs

Link: http://www.eprich.com/tools/simple-raid-group-calculator

2014-07-18_173113