1 Reply Latest reply on Feb 14, 2012 7:03 PM by Elias Ross

    How to display Top 10 results?

    Elias Ross Master

      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...