Mat has done an updated version of the heatmaps script for CLARiiON with LUN info and good things like that. You can download it here. Updated release notes can be found here. A sample of the output is here. Enjoy, and feel free to send requests for enhancements.
Pingback: EMC Clariion / VNX DIY Heatmaps Updated | TechDecode.Com
I tried running a few LUN oriented attributes and receive the following error:
Querying CSV file for LUN Service Time (ms)
system c:\Program Files (x86)\Log Parser 2.2\LogParser.exe -q -i:CSV -itsformat:
‘MM/dd/yyyy hh:mm:ss’ -headerRow:on SELECT DISTINCT TO_LOCALTIME(QUANTIZE(TO_LOC
ALTIME(Poll\u0020Time),1500)) as time, object\u0020name as lun,avg(Service\u0020
Time\u0020(ms)) as avg into tmp_heatmap_l_service_l.csv from tmp_analyzer_heatma
p_l.csv group by time,lun order by time,lun failed: 256 at ..\heatmap.3.011.pl l
ine 689.
Hi,
When doing LUN based attributes I am having issues. Check out this error.
Querying CSV file for LUN Response Time (ms)
system c:\Program Files (x86)\Log Parser 2.2\LogParser.exe -q -i:CSV -itsformat:
‘MM/dd/yyyy hh:mm:ss’ -headerRow:on SELECT DISTINCT TO_LOCALTIME(QUANTIZE(TO_LOC
ALTIME(Poll\u0020Time),1500)) as time, object\u0020name as lun,avg(Response\u002
0Time\u0020(ms)) as avg into tmp_heatmap_l_response_l.csv from tmp_analyzer_heat
map_l.csv group by time,lun order by time,lun failed: 256 at ..\heatmap.3.011.pl
line 689.
All other attributes work great!
Hey Phantasis,
Is there any chance you could run this again and mail me a copy of CSV files that are being generated – specifically the tmp_analyzer_heatmap_l.csv file
my e-mail address is matharvest@gmail.com
thanks
Mat.