Azure SQL Serverless DB resuming and pausing automatically

Question

Hi All,

We have created an Azure SQL serverless DB, which acts as a backup of our Azure SQL DB and hence after creation, no activity or logins happen in this serverless DB.

After creation, we are pausing the DB but it is getting resumed automatically every hour and getting paused due to Auto pause property.

Serverless

Upon checking there is no Event Initiated by and we also checked JSON script for Resume Databases activity and was not able to find the source-

Activitylog

Kindly help in identifying why the database is resuming automatically if no activity is happening.

Answer

Hi @Priya Jha,

Thanks for the question and using MS Q&A platform.

As I understand that your serverless DB is getting resumed automatically, there are some situations where Auto resuming triggers.

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

Feature	Auto-resume trigger
Authentication and authorization	Login
Threat detection	Enabling/disabling threat detection settings at the database or server level. Modifying threat detection settings at the database or server level.
Data discovery and classification	Adding, modifying, deleting, or viewing sensitivity labels
Auditing	Viewing auditing records. Updating or viewing auditing policy.
Data masking	Adding, modifying, deleting, or viewing data masking rules
Transparent data encryption	Viewing state or status of transparent data encryption
Vulnerability assessment	Ad hoc scans and periodic scans if enabled
Query (performance) data store	Modifying or viewing Query Store settings
Performance recommendations	Viewing or applying performance recommendations
Auto-tuning	Application and verification of auto-tuning recommendations such as auto-indexing
Database copying	Create database as copy. Export to a BACPAC file.
SQL data sync	Synchronization between hub and member databases that run on a configurable schedule or are performed manually
Modifying certain database metadata	Adding new database tags. Changing maximum vCores, minimum vCores, or auto-pause delay.
SQL Server Management Studio (SSMS)	When using SSMS versions earlier than 18.1 and opening a new query window for any database in the server, any auto-paused database in the same server is resumed. This behavior does not occur if using SSMS version 18.1 or later.

Please go through this documentation for Additional Information: Auto-resume.

If you cannot find any external or internal activities that are triggering the resume, consider opening a support request with Azure. They can provide more granular insights from their backend logs and give you a clear explanation if the automatic resume is due to internal maintenance or hidden processes.

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Azure SQL Serverless DB resuming and pausing automatically

1 answer

Your answer