vscsiStats 3D surface graph part 3: Build your own!

Some people have asked me how to actually create the 3D graphs from the vcsiStats tool. I use a simple Excel sheet for this. Using the script I described in vscsiStats into the third dimension: Surface charts! , you can import the files outputted into excel and see the Excel chart instantaneously.

The vscsiStats tool is a very powerfull vSphere utility. It allows you to see virtual disk performance (such as latency, IOPS block sizes etc). The script I used in part 1 and in part 2 of this series will shoot multiple samples of these values right after each other, which you can then import into Excel to produce surface charts, like this one:

3D surface chart example from the vscsiStats tool

How to create graphs like this is described in detail below.

Steps to perform

We’ll be going straight to the steps to perform to build yourself these graphs:

  1. Create a script file on the ESX node of your choice (using the info in part 1). I found it very useful to put all this stuff on a combined NAS/CIFS share, so you can work on it in both vSphere and your workstation;
  2. use the script to create a file “out1.csv” (or whatever you put in the script as a filename);
  3. Download the zip file containing the Excel sheet here;
  4. Doubleclick the Excel file to start it in Microsoft Excel (yes, you need to have Excel installed);
  5. Import the file created by the script;
  6. View the 3D surface charts!

All steps should speak for itself. Step 5 might require a more detailed description:

After opening, you should find yourself on the first tab. This is where the source csv file lives. You can insert your own just by right clicking anywhere in the sheet, and select “Edit text import”:

Import the new *.csv file into the Excel sheet

Next, you select the csv file you created in step 2. A new window opens where you can modify the csv import settings. Leave them as they are, and just click “finish”:

CSV import properties. Just click

Finally, Excel will prompt you with a potential security risk (if you did not enable the content beforehand). Just accept this by clicking OK:

Click ok to accept the fact you are importing data from an external source.

The last tab of the Excel sheet contains “variables”. Well, actually just one variable called “sample time”. This variable simply makes sure the timelines display the correct time. You should fill in the sample time you used in the script, and the timeline should adjust accordingly.

After the import completes and you adjusted the sample time, just check out the other tabs to see all your 3D graphs, without any further troubles! If a graph sometimes does not display nicely, you might need to adjust the 3D graph viewing angles. It’s all possible:

The final result: 3D charts easily created.

Pretty cool stuff 🙂

12 Responses to “vscsiStats 3D surface graph part 3: Build your own!”

Soon to come