Query Monitoring
  • 01 Jan 2023
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Query Monitoring

  • Dark
    Light
  • PDF

Introduction

Query monitoring aids in the tracking of critical queries that have an impact on the performance and overall operation of a business process in a business orchestration.

Serverless360 Business Activity Monitoring (BAM) allows users to receive notifications for the configured queries. Users can monitor the saved queries with the help of Query monitor supported by Serverless360 Business Activity Monitoring.

Query Monitoring

Query monitor in Business Activity Monitoring (BAM) provides the following categories of settings to begin with query monitoring:

Basic alert configuration.png

Alert Settings

The Query monitor settings provide two monitoring options that can be configured by the user. The two options include Rules evaluation frequency and Maximum alerts per hour.

  • Rules evaluation frequency is used to specify the time period for which data will be tracked using Query monitor. For example, if the schedule is set to run every 15 minutes, the Rules evaluation frequency will retrieve the number of records from the Serverless360 tracked data based on the time period specified.

  • Maximum alerts per hour is used to specify the number of alerts to be received per hour. Alerts will not be sent more than the maximum number of alerts per hour specified by the user.

Modes of alert configuration

Query monitor offers two different modes of alert configuration:

  • Basic alert configuration
  • Advanced alert configuration

Basic alert configuration

This alert configuration mode allows users to monitor saved queries with specified threshold values, where the configured mail address(es) and notification channels are shared by the selected queries.

Advanced alert configuration

This alert configuration mode enables users to configure notification channels and email address(es) individually concerning each saved query for monitoring.

Advanced alert configuration.png

Once all the settings are configured, the Query monitoring will be initiated once it is enabled and the query monitor will run based on the provided rules evaluation frequency and maximum alert limit per hour.

Saved queries

All queries saved by users for the corresponding business process will be listed here, along with threshold values that can be customized based on user preferences.

Resolution Notes

  • A resolution note is a brief description provided by the user for any rule violation.

  • The resolution note for query monitoring can be provided to specified query rules based on user's preferences.

Resolution notes.png

The image below depicts a sample query alert received via email:

Query alert.png


Was this article helpful?

What's Next