Why are thresholds and alerts not working in Database tab metrics of MS SQL monitor?
In Applications Manager's MS SQL monitor, metrics under Database tab are collected once in an hour by default. Therefore, under Admin -> Performance polling -> MS SQL -> Database Metrics, the option 'Collect SQL Database metrics once in an hour' is enabled by default. If this option is enabled, then the thresholds will be applied only once in an hour and the alerts will work based on that.
You can disable this checkbox in case you want to collect data for every poll.
Related Articles
Why are few database metrics in the Database tab showing empty values in MS SQL monitor?
Why are few database metrics in Database tab showing empty values in MS SQL monitor? Before Applications Manager version 13910, We were showing high-level metrics for MS SQL monitor's Database usage from SQL server performance counters. But from ...Azure SQL Database - FAQ
1. Why have we removed the Diagnostic Settings dependency in Azure SQL Database monitor? Till APM v15240: Azure SQL Database was using Diagnostic Settings to perform data collection. Prerequisites had to be fulfilled to turn on Diagnostic Settings ...How is Backup Age calculated for MS SQL DB monitor?
Backup Age displays the number of hours passed since the backup operation was completed. In simple terms, it is the difference between the current time and the time at which backup was performed. Backup Age (hours) = Current Time - Backup Time By ...No data available under Cluster details tab in MS SQL monitor
Run the Script: From the Applications Manager server, go to <AppManager_Home>\working\conf\application\scripts\ in a command prompt and run the script wincluster.vbs Usage: cscript wincluster.vbs <ClusterName> <UserName> <Password> 0 For Example : ...Problem occurs while adding MS SQL Monitor.
Solution: Check if hostname/IP address is resolving correctly from Applications Manager machine. Check if port is able to telnet from Applications Manager machine. If instance name is provided, check the UDP port(Default: 1434) is reachable. Check ...