h

IO

mon

™

  The File I/O Performance Monitor

Home  |  Products & Services  |  Contact  |  About hyperI/O^sm

Big Picture

hIOmon Fragmented File I/O Metrics Analysis Add-On 
Build Pivot Table/Chart Macro Extended Feature

Product Info

The hIOmon "Device and File I/O Performance Analysis Add-On" provides a Microsoft® Office Excel macro that can be used to easily and quickly generate a variety of charts and graphs using the Excel Pivot Table/Chart feature.  This "Build Pivot Table/Chart" macro can also be used by the hIOmon "Fragmented File I/O Operation Metrics Analysis Add-On", where the charts and graphs generated by the macro are based upon the "fragmented file I/O operation" performance metrics that have been imported from a hIOmon Manager Export File into the Excel worksheet using the hIOmon Excel template file.  The macro also enables you to optionally build a Pivot Table/Chart based upon user-specified period groupings as described below.

Features

Architecture

Screen Shots

Documentation

Download

Extended Feature of the hIOmon "Build Pivot Table/Chart" Excel macro

The hIOmon "Build Pivot Table/Chart" Excel macro makes generating Pivot Tables/Charts from the I/O operation performance metrics collected/exported by hIOmon both quick and easy.  An extended feature of this macro is the option to generate a Pivot Table/Chart based upon user-specified period groupings.

For example, you can specify that the first 100 rows within the "FragIOstatsExportFile" worksheet represent a "Baseline" period, with the following 140 rows representing the "Test" period.  To make such a distinction, simply add a new column to the worksheet with a column heading name of "Eval Period" (note that the "Eval Period" text string value must be used).  Then populate the cells within this column with a text string reflecting the particular periods that you want to evaluate.  

Following from the example above, the first 100 cells under the "Eval Period" column heading would contain the string "Baseline", with the following 140 cells within this column containing the string "Test".  The screen shot below provides a split view of the modified worksheet, with the "Eval Period" column heading added in column "AD" and the "Baseline" text value added into the "Eval Period" column cells from rows 2 through 49, followed with the "Test" text string value within the cells from row 50 to the last row within the table.  Essentially the "Baseline" period represents the metrics from date 5 hour 9 through date 5 hour 16; the "Test" period represents the metrics from date 5 hour 17 through date 6 hour 15 within the worksheet.

Note that the Excel "fill handle" feature can be used to quickly populate a contiguous range of cells with a particular value.

The added "Eval Period" column heading can be used with the macro to generate Pivot Tables/Charts based upon the "Eval Period" values together with one or more metric types (as represented by the other column headings).

For example, the following Pivot Chart was generated by selecting the "Eval Period" column heading along with the "Read IOP Count" column heading, then running the macro.  Notice that the "Baseline" value has been selected within the "Eval Period" button drop-down list in the top left-hand corner of the display.

Finally, the following screen shot shows the same Pivot Chart display, except that the "Eval Period" button has been moved (dragged) to above the "File Name" button on the right side of the display.  Notice that the "Read IOP Count" metrics are now displayed in terms of the "Baseline" and "Test" period values (e.g., "Baseline - E:" chart line and the "Test - E:" chart line).

The ability of the hIOmon "Build Pivot Table/Chart" Excel macro to optionally generate a Pivot Table/Chart based upon user-specified period groupings via the addition and use of the "Eval Period" column heading enables you to make, for instance, a variety of "before" and "after" comparisons of I/O operation performance metrics both quickly and easily.

Back to Top

hyperI/O^sm -  improving the performance of storage I/O in computer servers