Create a Query-based Widget Using Traces
You can create a query-based widget using Application Performance Monitoring traces.
You can use the many features available in the query-based widget builder to create a widget that displays a Trace Query Language (TQL) expression. The query-based widget builder provides you with options and functionalities to visualize and monitor trace data. For example, you can display transactions that scored low on performance when used by many customers, thereby making these transactions worthy of performance improvement efforts.
To create a query-based widget that displays trace data:
Here's a scenario in which the top 5 transactions in the specified time period are displayed using a line chart. In the query-based widget builder:
- Ensure that the time period is selected in the upper-right corner.
- In the Data source drop-down list, select Traces.
- In the Query field, enter the following
trace and click
Run.
show traces OperationName as Transaction, avg(traceDuration) as Duration where pageviews > 0 group by OperationName order by count(*) first 5 rows timeseries
- Specify the following on the Visualization
tab:
- Select Line chart as the Chart type.
- Select timeseries.Duration in the Y axis drop-down list.
- Select timeseries.date in the X axis drop-down list.
- Select Transaction in the Series drop-down list.
- Select Transaction in the Color by drop-down list.
A line chart with the top 5 transactions is displayed.