Why are thresholds and alerts not working for metrics in the Database tab of the MS SQL monitor?
By default, Applications Manager collects metrics under the Database tab of the MS SQL monitor once every hour. The Collect data control this behavior in every hour option under:
Settings → Performance Polling → MS SQL → Metric Name: Database
Since this option is enabled by default, thresholds are evaluated, and alerts are generated only once every hour for these metrics.
If you want thresholds to be evaluated and alerts to be generated at every polling interval, enable the Collect data during every poll option and click Save.
Note: Enabling Collect data during every poll increases the frequency of data collection for Database metrics, allowing thresholds and alerts to be evaluated at each configured polling interval instead of once per hour.
Refer to our feature page to learn more about SQL Server monitoring in Applications Manager.
New to ADSelfService Plus?
Related Articles
Why are some metrics in the Database tab of the MS SQL monitor showing empty values?
Before Applications Manager version 13910, we displayed high-level metrics for the MS SQL monitor’s database usage using SQL Server performance counters. From version 13910 onwards, we fetch detailed database-level metrics. As a result, some metrics ...Self monitor Applications Manager using Real User Monitoring
We can monitor the Applications Manager using Real User Monitoring with a Java Script injection and this can be used to measure the Applications Manager's performance continuously. All you need is to install and setup the Real User Monitoring (RUM) ...Troubleshooting issues while adding an MS SQL Monitor
1. Ensure that the SQL Server is running and accessible. Try connecting to the SQL Server instance via SQL Server Management Studio or DBVisualizer using the same credentials. This step helps diagnose connection issues, ensuring that both the server ...Database Query Monitor FAQ
How to fix an "Unable to find the Primary Key for tablename" error displayed after adding a query monitor? After adding a Database Query Monitor, users must select and update a Primary Key for each table. The primary key can be a single column or a ...How do I resolve the "No Data" issue for MS SQL performance metrics?
Problem: If the metrics in the MS SQL monitor's 'Overview' page aren't getting populated, it might be due to any of the following reasons: MS SQL user does not have permission to access the performance counters. Data collected from SQL Server is not ...