Does anyone know of a good way (other than Excel) to graph Perfmon Logs? Currently after a load test, I have to manually graph the necessary graphs derived from raw perfmon counter logs pulled from over 100+ servers (yes, this takes FOREVER).
Any suggestions on programs/tools? I know that LoadRunner has the monitoring capability but we have our own perf counters. Thanks!
Could you please provide more details:
What's wrong with excel? Could I suggest open office calc instead [img]/images/graemlins/smile.gif[/img]
Do you want to say that there are some counters perfmon is able to read, but LoadRUnner in unable to? Have you tried? Have you asked LoadRunner support about this?
[ QUOTE ]
With regards to Excel, you could use VBA/VBS to automate the complete process.
[/ QUOTE ]
That's what I was thinking... with hundreds of servers worth of data to graph there's got to be a way to automate pulling some of the "basic" counters that are similar across all servers and graphing those.
Then follow up and manually create any server specific counters you need to augment your report.
For easier management of perflogs or perfmon across many servers. It might be ideal to use its command line counterparts instead of the PerfMon GUI:
logman.exe - command line version of perfmon
typeperf.exe - on demand version of perfmon run/stop as needed on command line rather than "start/stop" the perfmon counter. No need to create a counter log to log data as it's on demand. Output to screen or log to file/database.
relog.exe - use to convert perflog log formats or to import to SQL server database.
I find these tools are more useful than perfmon itself.
Unfortunately, there are no command line perfmon tools to gather statistics and generate graphs for that, you'd need PAL mentioned in an earlier post on this thread.