Pausing Azure SQL Data Warehouse using an Automation Runbook

When a Azure SQL Data Warehouse is paused, all running queries are canceled. If there are queries running that have data movement, rollback operations will likely happen. These rollbacks can take many hours to complete. While these rollback operations are running, the service is not paused. In many cases, allowing the current actions to complete would prevent lost…

0