Azure SQL Data Warehouse: Troubleshoot with the Resource Health check
Posted on Wednesday, July 19, 2017
Reduce troubleshooting time with the upgraded Resource Health check in Azure SQL Data Warehouse.
This upgrade considers the health status of all components of the SQL Data Warehouse architecture, which includes each SQL database distribution and the SQL Data Warehouse engine on each compute node. Login and heartbeat signals of each component are emitted at least once every 2 minutes, providing you a low-latency, holistic view of the health status of your data warehouse. If your instance is Unavailable, we will provide the reason along with recommended actions that you should perform.
The Resource Health check can detect unavailability reasons, such as when your instance is pausing, scaling, or upgrading. This feature also detects when there are any connection issues, whether they are user connections or inner SQL database connections.
You check the health of SQL Data Warehouse by signing in to the Azure portal and clicking the Resource Health blade.