This issue typically occurs when the SQL Server user configured for monitoring does not have the required VIEW ANY DEFINITION permission.

To verify this, follow the steps below.

Step 1: Verify the SQL Server permissions

1. Connect to the AlwaysOn-enabled SQL Server using SQL Server Management Studio (SSMS) with the same SQL Server account configured for monitoring in Applications Manager.
2. Execute the following query:
   

Step 2: Verify the query result

Scenario 1: The query returns one row for each availability group hosted by the local SQL Server instance.

• This indicates that the required permissions are available.
• If the AlwaysOn Availability Groups page in Applications Manager still displays no data, share the following with the Applications Manager Support team:
  • A screenshot of the AlwaysOn Availability Groups page.
  • The Support Information File (SIF).

Scenario 2: The query returns no rows, even though the SQL Server instance is part of an availability group.

Scenario 3: The following error is returned:

Invalid object name 'sys.availability_groups'

Both Scenario 2 and Scenario 3 usually indicate that the monitoring user does not have the required VIEW ANY DEFINITION permission.

Grant the VIEW ANY DEFINITION permission to the monitoring user and verify whether the Availability Groups information is displayed correctly.

For more information, refer to the Prerequisites for Applications Manager documentation.

Note: The monitoring user must have sufficient permissions to query AlwaysOn Availability Group metadata. Without the VIEW ANY DEFINITION permission, Applications Manager cannot retrieve and display Availability Groups information.