In a previous post we discussed Building Reports in Profiler in Storage Manager, but I only gave one example (volume usage on hosts or VM).  A great way to leverage the reporting is to build ranking reports to identify hot spots in your environment - be it array, LUN, switch, host or VM, you can find the potential trouble points in your environment before they find you.

For example, say you wanted to identify LUNs based on different ranking criteria:  

  • Busiest LUNs on average in the  last 24 hours,
  • Busiest LUNs for one hour in the last 7 days
  • Least busy LUNs on average in the last 7 days

All can be done quickly with ranking reports, which can be combined into a single report in an email via a schedule (but more on that later).

To build a ranking report, first we need to pick a report template, so go to My Reports and press the New Report button.  In the drop downs, for OS select "Storage Array", then for Category select "Performance", then for Template select "LUN Performance". 

In the first screen, you can choose the columns for the report.  Move everything to the left by pressing the "<<" button, then select the fields "LUN ID", "Host Name" and "Total IOs/sec" from the available fields and pressing the ">" button.  Note I am leaving "Time" field out for now, more on why later.

Next, give the report a name and description, then we will edit the "Sort By".   First, clear out the Sort By text box by selecting each line and pressing the "Delete Sort" button.  Once all the default sorts are removed, then select "Total IOs/sec" in the first drop down and "Descending" in the second drop down, then click the "Add Sort" button.  When you are done with the Sort By section, it should look like this:

You can skip the Filters for now, as we want to rank all LUNs - but in the future, if you wanted to limit the list to a specific set of LUNs by name or pattern, you could do that in the filter section.  At the bottom of the page, press the "Save and Run" button  to execute your report.

When executing the report, you have the following options to choose from:

  • Groups: Which group of arrays for the report (default All)
  • Resources: Which arrays for the report (default All)
  • Data: The date rate (ex: Raw, Hourly, Daily, Weekly, Monthly)
  • Range: The time range, with both default and customizable ranges
  • Format: The output format of the report
  • Time Zone: What time zone the report times should be shown
  • Rows Per Page: How many rows to show in the report

Depending on what you want to rank, you will need to choose the appropriate data rate and time range.  Here are a couple of examples:

  • If you want the ranking to show only one data point per LUN, then you must synchronize the data rate and time range.  For example, if you want to rank the LUNs for the last 24 hours, then choose Data of "Daily" and the Range or "Last 24 hours".  For this report, I don't need the time field since each LUN has only one row.
  • If you want a ranking report to show multiple data points per LUN over a time range, then you don't need to synchronize the data rate and time range.  For example, if you wanted to rank the LUNs by the busiest hour in the last week, you would choose Data of "Hourly" and Range of "Last 7 Days".  For this report, I want the time field so I could identify the time it was busy.

Here is an example of a ranking report identifying the busiest LUNs in the last 24 hours (no time column):

Here is an example of a ranking report identifying the busiest hour for a LUN in the last 7 days (with time column):

Here is a report that looked at the weekly average for each LUN to identify LUNs that had no/low activity on them (no time column again) - these could be LUNs that you could reclaim.

Note this technique can be applied to any performance data in Storage Manager (RAID group, switches, hosts, servers, VM, etc.) including all the arrays we support (including EMC Clariion, NetApp, HP EVA, 3par, etc.), so don't hesitate to try them as well.

Thanks for taking the time to read our blogs, and as always, we would love to hear your thoughts and ideas on Storage Manager.

Extra Curricular Activities: