Query Monitoring
  • 01 Jan 2023
  • 2 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Query Monitoring

  • 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

Query Monitoring

Below are a few illustrations for configuring query rules for different resource types:

API Management Service

API Management Service.gif

APIM API

APIM API.gif

APIM Operation

APIM Operation.gif

Application Insight

Application Insight.gif

Azure Function

Azure Function.gif

Cosmos SQL Container

Cosmos SQL Container.gif

Cosmos Table

Cosmos Table.gif

Log Analytics Workspace

Log Analytics Workspace.gif

SQL Database

Sql Database.gif

Storage Table

Storage table.gif

Notifications

Query alerts are delivered to the configured notification channels and email addresses in the same way as all other monitoring alerts.

The image below is an example of a query alert for the Log Analytics Workspace resource received via email:

Alert.png


Was this article helpful?