Tag: IOPS

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

Visualizing SQLIO: Disk benchmark results using a PivotChart

This is a quick video of what I was working on for a little today. I created a batch script that will benchmark a disk(s) using SQLIO and record the output to a single file (or multiple, if necessary). After benchmarking completes, I run SQLIOResults and choose the output file that was created by my batch script.

Once SQLIOResults parses the SQLIO output and finishes inserting it into Excel, I create a PivotChart to compare the disk(s) IOPS and MB/s at each of the different test levels.

Hopefully someone else will find this useful. Also, if anyone knows how I can create a pivot chart in Powershell (if there’s a COM call), please let me know so I can completely automate this!