I have a process running in a Azure WebJob that generate an Excel file containing images and I want to measure the performance of this process in time.
This process has the following metrics;
- The number of images
- The time took to finish the excel
I want to create a graph that shows me how these two metrics variable over the time. Because I don't know how to create/judge a 3 axis graph I think of combining these two metrics into one so I can create a graph with [Time/Images per sec].
Should I segment the data into divisions such as Many images(>300), some images (>100) and few images(<100)?
How should I store the data in db? My initial thoughts are to store the raw data in a table and with a WebJob crunch the data every night and produce daily, weekly and monthly sums.