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!<\/a> , you can import the files outputted into excel and see the Excel chart instantaneously.<\/p><\/blockquote>\n How to create graphs like this is described in detail below. We’ll be going straight to the steps to perform to build yourself these graphs:<\/p>\n All steps should speak for itself. Step 5 might require a more detailed description:<\/p>\n After opening, you should find yourself on the first tab. This is where the source csv<\/em> file lives. You can insert your own just by right clicking anywhere in the sheet, and select “Edit text import”:<\/p>\n 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”:<\/p>\n Finally, Excel will prompt you with a potential security risk (if you did not enable the content beforehand). Just accept this by clicking OK:<\/p>\n 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. <\/p>\n 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:<\/p>\n Pretty cool stuff \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":" 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 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[77,5],"tags":[183,186,184,72,185,182,181,109,632,119,99,180],"class_list":["post-1022","post","type-post","status-publish","format-standard","hentry","category-storage","category-vmware","tag-3d-chart","tag-block-size","tag-disk-latency","tag-iops","tag-iops-size","tag-surface-chart","tag-surface-graph","tag-virtual-disk","tag-vmware","tag-vscsistats","tag-vsphere","tag-vsphere-4"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.vmdamentals.com\/index.php?rest_route=\/wp\/v2\/posts\/1022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vmdamentals.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vmdamentals.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vmdamentals.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vmdamentals.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1022"}],"version-history":[{"count":51,"href":"https:\/\/www.vmdamentals.com\/index.php?rest_route=\/wp\/v2\/posts\/1022\/revisions"}],"predecessor-version":[{"id":3650,"href":"https:\/\/www.vmdamentals.com\/index.php?rest_route=\/wp\/v2\/posts\/1022\/revisions\/3650"}],"wp:attachment":[{"href":"https:\/\/www.vmdamentals.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vmdamentals.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vmdamentals.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nThe 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<\/a> and in part 2<\/a> 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:<\/p>\n![\"3D](\"http:\/\/vmdamentals.com\/wp-content\/uploads\/2011\/12\/IOmeter-readdist.png\")
<\/center><\/p>\n
\n
\nSteps to perform<\/strong><\/p>\n\n
![\"Import](\"http:\/\/vmdamentals.com\/wp-content\/uploads\/2011\/12\/import.png\")
<\/center><\/p>\n![\"CSV](\"http:\/\/vmdamentals.com\/wp-content\/uploads\/2011\/12\/finish.png\")
<\/center><\/p>\n![\"Click](\"http:\/\/vmdamentals.com\/wp-content\/uploads\/2011\/12\/warning.png\")
<\/center><\/p>\n![\"The](\"http:\/\/vmdamentals.com\/wp-content\/uploads\/2011\/12\/result.png\")
<\/center><\/p>\n