Why is Serverless DB resuming automatcally without any activity?

Question

Hello,

I have created a ServerLess Azure SQL Database to understand how it works. I am not doing anything on this DB but still I see from its activity log that it has been paused twice and resumed twice for no reason. I am not sure why it resume after pausing for first time?

I tried going through Activity log event JSON but couldn't find any reason for resuming the database.

Appreciate your insightful response, thank you !!

{
"channels": "Operation",
"correlationId": "94219D1C-8452-4B39-9764-9D762B0770B5",
"description": "",
"eventDataId": "710a1fa4-60ea-4e46-9550-8f3b223e369e",
"eventName": {
"value": "",
"localizedValue": ""
},
"category": {
"value": "Administrative",
"localizedValue": "Administrative"
},
"eventTimestamp": "2021-11-30T03:16:04.8112659Z",
"id": "/SUBSCRIPTIONS/266353D3-DAED-47AD-AD15-CAEEDA27DEA8/RESOURCEGROUPS/TESTAK/PROVIDERS/MICROSOFT.SQL/SERVERS/VARIANAK/DATABASES/SERVERLESSDB/events/710a1fa4-60ea-4e46-9550-8f3b223e369e/ticks/637738389648112659",
"level": "Informational",
"operationId": "",
"operationName": {
"value": "Microsoft.Sql/servers/databases/resume",
"localizedValue": "Microsoft.Sql/servers/databases/resume"
},
"resourceGroupName": "",
"resourceProviderName": {
"value": "MICROSOFT.SQL",
"localizedValue": "Microsoft SQL"
},
"resourceType": {
"value": "MICROSOFT.SQL/servers/databases",
"localizedValue": "MICROSOFT.SQL/servers/databases"
},
"resourceId": "",
"status": {
"value": "Started",
"localizedValue": "Started"
},
"subStatus": {
"value": "",
"localizedValue": ""
},
"submissionTimestamp": "2021-11-30T03:16:04.8112659Z",
"subscriptionId": "",
"tenantId": "",
"properties": {
"originalEventTimestamp": "11/30/2021 3:15:38 AM",
"CorrelationId": "94219D1C-8452-4B39-9764-9D762B0770B5",
"EventId": "f2cc5c2c-7ef7-48d1-a7c5-e9a4e6d138d0",
"EventName": "ResumeDatabase",
"OperationName": "Microsoft.Sql/servers/databases/resume",
"Status": "Started",
"Description_scrubbed": "Auto-resume SQL Database ServerlessDB on Server .....",
"Caller": "Unavailable",
"CallerCredentialType": "NotSpecified",
"EventChannel": "OperationLogStore",
"IpAddress": "",
"EventSource": "SQL Databases Event Supplier"
},
"relatedEvents": []
}

Answer 1

Hi @anil kumar Thank you for posting your question on Microsoft Q&A and sorry for the delay in my response.

There are several scenarios that are known to cause that. Some are documented here. For example, if auditing is enabled this can happen right now.

Regards,
Oury