-2

Recently whenever I access my SQL Server High Availability Dashboard, it comes up blank and I am not able to see the databases and the synchronization between the servers. Is there a solution to getting the dashboard to display the information again?

1
  • I'm assuming you're using AlwaysOn Availability Groups? If so, what does the following query show when you run it: USE master; SELECT * FROM sys.dm_hadr_availability_replica_states; ? Particularly you'll want to look at the operational_state_desc, recovery_health_desc, synchronization_health_desc, and connected_state_desc columns. Please add the results to your post (and which version and edition of SQL Server you're using). The aforementioned query uses a system DMV that is used by the High Availability Dashboard under the hood.
    – J.D.
    Jun 9, 2022 at 12:16

1 Answer 1

0

There was a known issue with SSMS 18.11.1 and SQL Server 2016 and below AG's. I do not know if it is fixed in the new 18.12 version. You can use 18.10 without any issues.

https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16#18111

Availability Group Dashboard Connecting to the Availability Group Dashboard for an AG on SQL Server 2016 and below results in "unknown property ClusterType" error. Use SSMS 18.10 to access the AG Dashboard for SQL Server 2016 and earlier.

2
  • Thank you for your answer and yes we are using SSMS 18.11 I will install 18.10 and test and update the thread. Jun 11, 2022 at 6:11
  • I just installed SSMS 18.12, and this fixed the bug.
    – Jim
    Jun 13, 2022 at 12:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.