Query monitoring

Overview

Query monitoring lets you track the results of saved queries against your Push Model business process data in Business Activity Monitoring (BAM) and receive alerts when the query results meet or exceed configured thresholds. You can monitor query output on a recurring schedule and route alerts to the appropriate teams through notification channels.

Query monitoring is also available in the Pull Model. For Pull Model query monitoring, see Query monitoring.

Business value

Many operational issues in integration environments become visible through patterns in tracked data — unusual volumes, missing records, or unexpected counts — before individual transactions start failing. Query monitoring lets you codify these signal patterns as saved queries and receive proactive alerts when the data deviates from expected ranges, reducing the time between anomaly and response.

How it works

Query monitoring works by running saved queries on a schedule — defined by the Rules evaluation frequency — and evaluating the result count against alert thresholds you configure. When the result exceeds the threshold, BAM sends an alert to your configured notification channels up to the Maximum alerts per hour limit.

You choose from existing saved queries in the Tracking section of a Push Model business process. Queries are evaluated independently, and each can have its own aggregation period, condition, warning and error thresholds, and notification channels in advanced mode.

Prerequisites

Required permissions

Steps

Use the following steps to configure query monitoring for a Push Model business process. Navigate to Business Activity Monitoring > your business process > Monitoring to get started.

Configure alert settings

Set the evaluation schedule and alert rate limit before adding queries.

1. Select the Query monitor tab (accessible under the Monitoring tab of your business process).
2. Set the Rules evaluation frequency — the interval at which BAM retrieves records and evaluates them against your thresholds. For example, setting this to 15 minutes causes the query monitor to check the last 15 minutes of tracked data every 15 minutes.
3. Set the Maximum alerts per hour — the maximum number of alerts BAM sends per hour, regardless of how many threshold violations occur.

Choose the alert configuration mode

Query monitoring supports two alert configuration modes.

Basic alert configuration — all selected queries share the same notification channels and email recipients. You can assign an escalation policy in this mode.

Advanced alert configuration — notification channels, thresholds, and aggregation periods are configured individually for each query.

Configure basic alert configuration

1. Select Basic alert configuration.
2. Select an Escalation policy if required. Escalation policy is only available in basic mode.
3. Enter a Recipient email address and select an Email template.
4. Under Select the channels, check each notification channel that should receive the alert.
5. Click Update to save the configuration.

Add saved queries (advanced alert configuration)

In advanced mode, each query is configured as an individual rule with its own thresholds and notification routing.

1. Select Advanced alert configuration.
2. Click + Add query.
3. Select a saved query from the query library displayed in the configuration for the business process.
4. Set the Aggregation period — the time window BAM uses to evaluate the query results.
5. Set the Condition — the operator used to compare the query result count against the thresholds (for example, >).
6. Set the Warning threshold — BAM fires a warning alert when the query result count meets this condition.
7. Set the Error threshold — BAM fires an error alert when the query result count meets this condition.
8. Optionally enter a Note — shown on the query rule for reference.
9. Configure the Notification channels for this query rule.
10. Click Update to save.

Once enabled, the query monitor runs according to the rules evaluation frequency and sends alerts up to the maximum alerts per hour limit.

Sample query alerts received via email:

Enable or disable monitoring

You can enable or disable all monitoring rules for a business process or business process group without deleting your configuration. This is useful for temporarily suspending alerting during maintenance or testing.

1. Navigate to Business Activity Monitoring > your business process > Monitoring.
2. In the top-right corner of the Monitoring view, open the Monitoring status dropdown.
3. Select Enable to activate monitoring, or Disable to pause all monitoring rules for the business process.

Configuration

Limitations

• Advanced queries saved in the Tracking section of a business process are not listed for query monitoring. Only standard saved queries are available.
• Queries added in the Query monitor section do not appear in the Tracking section of the business process.
• Escalation policy assignment is available in basic alert configuration mode only.
• Disabling monitoring via the Monitoring status dropdown suspends all monitor types for the business process, not only query monitoring.

Troubleshooting

1. A saved query does not appear in the Add query list
   Cause: The query may be an advanced query saved in the Tracking section. Advanced queries are not available for query monitoring.
   Fix: Use only standard saved queries from the Tracking section. Convert the query to a standard saved query if needed.

2. No alert was received after the evaluation frequency elapsed
   Cause: The query monitor may not be enabled, or the query result did not meet the threshold.
   Fix: Open the Monitoring tab, confirm Monitoring status is set to Enabled, then verify the query monitor is active and the configured threshold matches the expected query result volume.

3. Alert volume is too high
   Cause: The Maximum alerts per hour limit may be set too high, or multiple queries are matching frequently.
   Fix: Lower the Maximum alerts per hour value or adjust the query threshold to reduce false positives.

4. Escalation policy option is not visible
   Cause: The alert configuration mode is set to Advanced. Escalation policy is only available in basic mode.
   Fix: Switch to basic alert configuration mode to access the escalation policy option.

5. Resolution note is not appearing in the alert
   Cause: The resolution note may not have been saved, or the alert was generated by a query that does not have a resolution note configured.
   Fix: Open the query monitor configuration, confirm the note is entered for the relevant query rule, and save the configuration.

FAQs

1. Can I monitor queries from multiple business processes in a single query monitor?
   No. Query monitoring is configured per business process. Each business process has its own query monitor with its own saved queries and settings.

2. Can I assign different notification channels to different queries?
   Yes. Switch to advanced alert configuration mode to configure notification channels and email recipients individually for each query.

3. What is the difference between Rules evaluation frequency and Maximum alerts per hour?
   Rules evaluation frequency controls how often BAM checks your data — for example, every 15 minutes. Maximum alerts per hour limits how many alert notifications BAM actually sends within an hour, regardless of how many threshold violations the evaluation finds.

Related articles

• Duration monitoring
• Exception monitoring
• Summary alerts
• Managing escalation policies
• Querying transaction instances