6

I created a serverless sql on azure and didn't use it for few weeks. Now when I go back to it, I found it's in Pause status.

But searching the azure dashboard, I can't find any way to resume it. When I google this topic, all result are talking about how to resume Dedicated SQL pool which appears to be a different thing.

How to bring it back online?

Circle Hsiao
  • 445
  • 5
  • 18

2 Answers2

6

Once the Azure Database is in pause status, it resumes automatically in the following conditions:

  • Database connection
  • database export or copy
  • Viewing auditing records
  • Viewing or applying performance recommendation
  • Vulnerability assessment
  • Modifying or viewing data masking rules
  • View state for transparent data encryption
  • Modification for serverless configuration such as max vCores, min vCores, or auto-pause delay

https://www.sqlshack.com/automatic-pause-and-resume-an-azure-sql-database/

Aleksey Vitsko
  • 5,589
  • 5
  • 34
  • 64
5

How about the official documentation ?

https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview

Auto-resuming is triggered if any of the following conditions are true at any time:

  • Login Enabling/disabling threat detection settings at the database or server level.

  • Modifying threat detection settings at the database or server level.

  • Adding, modifying, deleting, or viewing sensitivity labels Viewing auditing records.

  • Updating or viewing auditing policy.

  • Adding, modifying, deleting,or viewing data masking rules

  • Viewing state or status of transparent data encryption

  • Ad hoc (vulnurability) scans and periodic scans if enabled Modifying or viewing query store settings

  • Viewing or applying performance recommendations

  • Application and verification of auto-tuning recommendations such as auto-indexing

  • Createdatabase as copy.

  • Export to a BACPAC file.

  • Synchronization between hub and member databases that run on a configurable schedule or are performed manually Adding new database tags.

  • Changing max vCores, min vCores, or auto-pause delay.

  • Using SSMS versions earlier than 18.1 and opening a new query window for any database in the server will resume any auto-paused
    database in the same server. This behavior does not occur if using
    SSMS version 18.1 or later.

The latency to auto-resume and auto-pause a serverless database is generally order of 1 minute to auto-resume and 1-10 minutes after the expiration of the delay period to auto-pause.

At first glance Resume-AzSqlDatabase looks promising, but it will fail. https://learn.microsoft.com/en-us/powershell/module/az.sql/resume-azsqldatabase says only

The Resume-AzSqlDatabase cmdlet works only on Azure SQL Data Warehouse databases. This operation is not supported on Azure SQL Database Basic, Standard and Premium editions.

Orangutech
  • 151
  • 1
  • 3