| title | Availability group dashboard in SSMS | |
|---|---|---|
| description | Learn about the Options page found on the SQL Server Always On Dashboard in SQL Server Management Studio. | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| ms.date | 05/17/2016 | |
| ms.service | sql | |
| ms.subservice | availability-groups | |
| ms.topic | conceptual | |
| f1_keywords |
|
[!INCLUDE SQL Server]
Use the SQL Server Always On Dashboard page of the [!INCLUDEssManStudioFull]Options dialog box to configure the Always On Dashboard.
To access this page:
On the Tools menu, click Options, expand the SQL Server Always On folder, and then click Dashboard.
Turn on automatic refresh.
Click to enable automatic refresh. The options are:
-
The Refresh interval (in seconds) field displays the number of seconds at which the dashboard will refresh. The default value is 30. When automatic refresh is enabled, you can edit this field to change the refresh interval.
-
The Number of connection retries displays the number of times that the dashboard will attempt to connect to an instance of [!INCLUDEssNoVersion] that hosts an availability replica for an availability group that the Dashboard is monitoring. The default value is 65535. When automatic refresh is enabled, you can edit this field to change the number of connection retries.
Enable your user-defined Always On policy.
If you have defined your own Always On policy, click this option to enable your policy.