Why are thresholds and alerts not working in Database tab metrics of MS SQL monitor?
In Applications Manager's MS SQL monitor, metrics under the Database tab are collected once every hour by default. This is controlled by the 'Collect data in every hour' option under Settings → Performance Polling → MS SQL → Metric Name: Database, which is enabled by default.
When this option is enabled, thresholds are evaluated, and alerts are triggered only once per hour. To collect data and evaluate thresholds at every poll interval, you can enable the Collect data during every poll option and click on Save.
New to ADSelfService Plus?
Related Articles
Why are a few database metrics in the Database tab showing empty values in the MS SQL monitor?
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 MS SQL Monitor Addition Problems
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 ...Why are alerts for network interfaces not raised when the configured thresholds are crossed?
In Linux SSH mode of monitoring, alerts will be triggered according to the following conditions. When the interface name starts with 'bond', alerts will be raised. When the interface has a master name as 'bond', alerts will be skipped. When an ...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 ...