July 21, 2009 at 12:09 pm
Just curious if anyone knows of any programs or tools to compare performance logs from system monitor.
I have them set up to run every day and I'd like to make a graph that charts each counter's value for each day of the week across a graph. It would be cool to look at the avg counter value across a week on a graph. Some ideal options would be to import a group of logs to load the graph, show / hide counters from the logs, and change the counters values from avg, max, min, etc to see how each compares...
Does anyone know of anything that can do this for me, or something like it?
July 21, 2009 at 12:20 pm
Well, I just realised I could view the counter values from several days in the system monitor, but it just takes the the logs and concatenates them together.
What I was looking for was something that would have the avg value for the Y axis, and the day of the week for the X axis. That would be easier to look at.
July 30, 2009 at 12:53 pm
Just letting you know I found the solution to this problem. You can create csv reports from each day's performance log. You open csv with excel, use avg(col range) to get summary data for that day, then you copy and paste the summaries into a single file, one line = one day avg. Then you create a chart in excel and it does exactly what I wanted.
I even wrote a little program that automates the work in this. It takes the source csvs, adds the avgs, creates 3 summary excels for min, avg, and max. Then after it runs I just open the summary files and add a line graph. Its really easy and works great!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply