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 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 ...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, ...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 ...
