Options (SQL Server Always On, Dashboard Page)
Updated: May 17, 2016
Applies To: SQL Server 2016
THIS TOPIC APPLIES TO: SQL Server (starting with 2016)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse
Use the SQL Server Always On Dashboard page of the SQL Server Management StudioOptions 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 SQL Server 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.