Query Monitoring

Updated on 01 Jan 2023
2 Minutes to read
Contributors

Print
Share
Dark

Light
PDF

Introduction

Any critical queries that impact the performance and availability of the business should be monitored. Serverless360 now includes the ability to perform query monitoring on a resource.

Supported resource types

Query monitoring is available for all the resource types that support querying:

API Management Service
APIM API
APIM Operation
Application Insight
Azure Function
Cosmos SQL Container
Cosmos Table
Log Analytics Workspace
SQL Database
Storage Table

APIMs and Azure Function require an application insight resource to be associated onto the same Business Application to begin with Query monitoring.

Rules configuration

Users can configure query rules for the resource by selecting the resource and navigating to Queries sub-tab under Monitoring.

The Add button in the Queries sub-tab under Monitoring allows users to create a query rule.

The first step in creating a query rule is to provide a friendly name to the query rule.

The second step is to enter a scalar query or select a query from the saved queries and validate it. The query rule can be saved only if the validation is successful.

The next step is to configure the threshold values.

Users can set two types of threshold values for each query rule:

1. Warning threshold
2. Error threshold

When the monitor evaluates the configured rules, any rule whose current value exceeds one of the threshold values is considered a violation.

A consolidated alert report is generated and sent to the configured email addresses and notification channels for the configured rules of all monitored resources in a Business Application.

The condition, warning, and error thresholds of all the query rules can be edited as bulk using the Save button in the Queries tab. Query rules can be updated and deleted by using the options next to each saved query rule.

Scalar query result from the resources like Application Insight, Cosmos SQL Container, Log Analytics Workspace, and SQL Database is used for evaluation, whereas in the case of Cosmos Table, Storage Table the row count returned by the query is used for evaluation.

Resolution Notes

A resolution note is a brief description provided by the user of any rule violation for which the user defines the appropriate action to be taken or a customized description.
The provided note will be displayed along with the violation alert notification in the configured channels.
Consider the situation in which a query used for monitoring exceeds the error or warning threshold value and the user is compelled to take action. The user can offer a quick summary of what action should be taken, with the help of a resolution note.

The below image shows how to configure resolution notes for a query rule violation:

Resolution notes for Query monitoring.png