With the recent release of the VMware Aria Operations for Applications product we have released the Query Analyzer feature which allows you to analyze your queries and subqueries. When you expect to see certain data in VMware Aria Operations for Applications, but it doesn’t show up for some reason, charts will display a No Data message. If you see this message on a chart, use the Query Analyzer to analyze and troubleshoot your queries and subqueries.
When your charts show No Data on the chart, you can use the Query Analyzer to analyze your queries and/or subqueries (unless you have overridden this setting and have set up charts to show a custom message as opposed to the standard No Data message). The Query Analyzer helps you identify potential issues in your queries, so that you can easily troubleshoot missing data, and also shows performance statistics for the queries and subqueries that result in No Data.:
Note: If you use variables in your queries, the Query Analyzer replaces the variables with their actual (static) values. For example, if the query that you want to analyze is max(${latency}), where the latency variable is ts(requests.latency, source="app-1*" or source="app2*", env="dev"), in the Query Analyzer, the query that you’ll see will be: max(ts(requests.latency, source="app-1*" or source="app2*", env="dev")).
If this feature is so useful, how does one actually use it … let’s take a look ….
Analyze a Query
- Click the name of the chart that shows ‘No Data’ to open it in Edit mode.
- If you have more queries, locate the query that you want to analyze.
- Click the ellipsis icon next to the query and select Query Analyzer. A new browser tab with the Query Analyzer will open.
Click Analyze.
The subquery that causes the No Data issue is highlighted.
There can be more than one reason why a query can show ‘No Data’, some of the reasons could be:
- If the subquery contains a typo.
- No data is present in Aria Operations for Applications.
- Or the query contains one or more subqueries that result in No Data.
As you can see from the Query Analyzer screenshot above, the Query Analyzer also shows performance statistics at a subquery level for a specific time window of 2H by default:
- Cardinality: Shows the number of unique time series.
- Points Scanned: Tells you the number of data points that were queried to show the chart on the screen.
- Duration: Shows the time between start of the query and return of the result.
If a query contains more than one subquery that results in No Data, when you analyze the query, the first subquery causing the issue is highlighted and the result for it is displayed under Detected Issues. The other subqueries resulting in No Data are marked with a dotted underline. To expand the result for another subquery, simply click a result under Detected Issues and the subquery will be highlighted.
To learn about the query analyzer in depth checkout our detailed documentation
Now that we have looked at the Query Analyzer by VMware Aria Operations for Applications ( Tanzu Observability or Wavefront by VMware) we suggest you give this a try and report any suggestions and improvements based on your usage and provide feedback via official channels if any …! You can also learn more about other VMware Aria Operations for Applications features on TechZone !
