DX Application Performance Management

  • 1.  Top 10 SQL Response times

    Posted Oct 07, 2016 04:41 AM

    Good morning,

     

    Our customer needs a dashboard with the Top 10 time consuming SQL commands in a database.

    So I create a metric grouping using this regexp:

         Backends\|bk(.*)\|.*Average Response Time \(ms\)

    But the resulting dashboard is pretty much useless for the customer, because we get over 100 hots, and the metrics are not sorted by the Response Time value, either.

     

    Does anyone know a solution for that?

    We would ideally want a sorted Top 10.

     

    Thanks!

    Mikel.



  • 2.  Re: Top 10 SQL Response times
    Best Answer

    Broadcom Employee
    Posted Oct 07, 2016 04:50 AM

    Hi Mikel,

     

    When you add the graph to the dashboard and select that metric grouping you can then apply a filter to it where you can select TOP-N values

     

    thanks

    Mike



  • 3.  Re: Top 10 SQL Response times

    Posted Oct 07, 2016 05:33 AM

    Thank you veryu much Mike.

    But are we sure that the Dashboard will show the Top 10 of ALL the SQL operations,

    or only the Top 10 of the 100 SQL operations in the Metric Grouping?



  • 4.  Re: Top 10 SQL Response times

    Broadcom Employee
    Posted Oct 07, 2016 06:15 AM

    Hi Mikel,

     

    As far as I understand it the data returned in the metric grouping regex is filtered before it is displayed on the graph so it should be the top-n of all matching queries not the top 10 of  subset of values. However you should exercise some caution with top-n queries as they can have a performance impact if the underlying grouping returns a very large number of metrics - particularly when viewing historical data.

     

    thahnks

    Mike



  • 5.  Re: Top 10 SQL Response times

    Broadcom Employee
    Posted Oct 07, 2016 07:52 AM

    Hi Toni: 

    From the response, it looks like Mike's suggestion will give your customer the data that they need. Please try it out and report back if it meets their requirements.Converted this to a question and marking it as answered. You are also welcome to post additional follow-up questions if required.

    Thanks

    Hal German