PowerScale: OneFS: How to Visualize Performance Data for 'isi statistics'

Summary: Performance data can be hard to analyze, but tools like Excel make it easier to spot trends. InsightIQ provides these performance views natively; when it is unavailable, import the data into Excel to create similar visualizations. ...

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

Accelerate analysis of isi statistics performance data, by graphing it visually.

Cause

Working with performance numbers can be difficult to sift through and analyze.

Resolution

  1. Gather Performance data, use the --noconversion and the --.csv switches commands.
Example: 
# isi statistics drive --noconversion --csv --nodes=1 --degraded

Note: If the data was not gathered as .csv (Comma-Separated Values) it can be converted to .csv, or import with a different delimiter. Here is an example of how to convert it: 
# while  $file;do echo "Please enter the full path to the file.";read file;done;echo "Processing "$file".";awk 'NF >0' $file|sed -e 's/ \+ /,/g' -e 's/\ /,/g'|cut -c 2-|tee $file.csv
This asks you to provide the path to the file, and it creates a copy with the same file name with .csv at the end.
 
  1. Once you have your data in a text file that has a .csv format, you can import it into Excel.
    1. In Excel, go to the Data tab
    2. Under Importing options, choose From Text.
    3. Find your file and select Import.
    4. Choose Delimited, press Next
    5. Choose Comma for the delimiter type.
    6. Select Finish
  1. Graph the dataset:
    1. It is recommended to remove the following line, or your graph is 1 off. 
LNN:bay,,N/s,B/s,N/s,B/s,ms,ms,,%
  1. Highlight your dataset.
 
Note: If you are working with multiple statistics, only highlight data of the same units. Otherwise, your graph is skewed.
 
  1. Go to the Insert tab.
  2. Select type of graph (Column, Line, or Scatter plot are good for most situations).

An example is attached named 'Example Output.png'.

Affected Products

Isilon
Article Properties
Article Number: 000094828
Article Type: Solution
Last Modified: 17 Dec 2025
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.