Visualizing SQLIO: Disk benchmark results using a PivotChart

Your ads will be inserted here by

Easy AdSense Lite.

Please go to the plugin admin page to paste your ad code.

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!

About Rich Kreider

Hello, world! I'm over 1/4 of a century old. I'm just another tech guy swinging from vine to vine in the jungle of technology and life. I currently work for an IT consulting firm in northwestern Pennsylvania and before that I was a system administrator for a small ISP that was centrally located in Ohio's Amish area. The answer is 42.
This entry was posted in Windows and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>