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 monitor in Business Activity Monitoring (BAM) provides the following categories of settings to begin with query monitoring:
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.
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.
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.
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.
The image below depicts a sample query alert received via email: