How to check when Azure SQL Serverless instance is paused retroactively?

Question

Basically title, I have a bunch of Azure SQL Serverless instances which are all configured to be auto-paused after 1 hour of inactivity. Is it possible to check if/when the pauses happen retroactively? For example in last week, last 30 days and so on. I know I can easily check CURRENT status of each database, but I cannot find a way to do so for past periods. HELP! I've googled the crap out of this question and can't seem to find an answer.

Answer 1

Hi Arturas,

You can see this in the Azure portal using Change Analysis:

https://portal.azure.com/#view/Microsoft_Azure_ChangeAnalysis/ChangeAnalysisBaseBlade

Once you have Change Analysis open, click Add Filter, select Resource type: SQL databases, click Time range and change it as desired. In the output you are looking for properties.status and properties.pausedDate, as shown below:

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP

Answer 2

@Arturas Zuta
Thank you for reaching out. Checking the retroactive pause history for your Azure SQL Serverless instances can be useful for monitoring and understanding their behavior. Currently, auto-pause history is not directly available in Azure SQL Serverless. Our product group is working on it, but we don't have an ETA yet. I don't think it is possible to get that information yet, but you can try the options suggested by the community above. Regards, Oury