No data available in 'Availability Groups' table under 'AlwaysOn Availability Groups' tab in MS SQL monitor
Solution: Check whether 'VIEW ANY DEFINITION' permission is given to monitor AlwaysOn Availability Groups. To do so, follow the steps given below:
- Connect AlwaysOn enabled server in SQL Server Management Studio with the username which is used to monitoring in APM.
- Execute select * from sys.availability_groups.
- Possible results of the above query.
- Returns a row for each availability group for which the local instance of SQL Server hosts an availability replica.
- Even though the connected server is a replica of an availability group, it returns an empty row.
- Exception like "Invalid object name 'sys.availability_groups' " thrown.
- If the result is 'a' and it does not display the Availability group Details in APM UI, then share SIF and Screenshot of the AlwaysOn Availability Groups Page
- If the result is either 'b' or 'c', then 'view any definition' permission is not given for the SQL user.
- Refer the below link to grant permission for 'VIEW ANY DEFINITION'
New to ADSelfService Plus?
Related Articles
APM Insight monitor is UP, but monitor page doesn't show any data
Possible Causes The APM Insight monitor status corresponds to the respective agent folder pointed Java Application status i.e., as long as the Application server is running, the monitor status will be UP. 1. No Transactions Recorded: It is possible ...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) ...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 ...Script/Custom Monitors - Alarms configured for Table rows were missing
In the Applications manager , users have the ability to manage the table rows of a script or custom monitor type according to their specific requirements. This can be done by enabling the "Enable Script Row Deletion" option. For example, let's ...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 ...