Hi Robert !
I liked your post !!! Congratulations !!!
I did something from this way, but after collected, imported in SQL Server using Relog.
I needed to create combination between some counters, to have informations that i could compare with some metrics.
Other counter, i used only to baseline.
Because i wanted to generate an application, i needed to create some formulas with the counters used with metrics, formulas that were interpreted by a stored procedure. Some metrics have intervals (disk has good, bad,etc..), and others only limits.
I had samples by minute, so in a month, around of 42.000 samples.
Then wanted to generate some graphics to see the infomation better, but 42.000 samples are alot!!!
I put some filters to use in population, to get the job interval and, in some cases, didnt get weekdays.
Then, finally, i needed to do a store procedure to get less samples, but, without lose the major (or minor, depending the counter) values to put in graphics. I did a stored procedure that have two parameters, how many major (or minor) values and how many samples between two major (or minor) samples.
I think that you will talk about in next time.