I'd like a way to capture the top 10 ten database queries by CPU usage. (We're also looking at capturing the top ten processes, ala "top"). This would be captured hourly.
I know I can capture that data as a single trait or possibly 10 different traits. What is the recommended way to capture and display this sort of data?
I also would like to capture data off of each query like the amount of CPU used, username, host, etc.
Basically I'm looking for a table but I would probably settle for something that was a big string with line breaks.
If captured hourly, then I also wonder how would data be cleaned up (purged) or even displayed? There are 8000 hours in a year...
I'm thinking the best way to do this is to have a scheduled operation that is run every hour or so, similar to the process list component.