How can we help you today? How can we help you today?

Will Monitor prevent an Azure SQL Database from auto-pausing?

We are beginning to “modernize” applications moving them into Azure, including the databases.  One of the points they are looking to take advantage of in Azure SQL is being able to auto-pause a database when it's not in use.

My question is if having Monitor connected to said database would prevent Azure from pausing the database through the regular collection of performance data, etc?

Jason A
0

Comments

3 comments

Sort by
  • Sergio Rocha
    Official comment

    Hi Jason,

    Yes, I am afraid it will.

    Sergio Rocha
  • Mick Gray

    Hi Jason
    if you use the Redgate PowerShell module you can create a script to suspend or restart the monitoring, this is what we do to allow our azuresql dbs to auto pause. bit of a faff when you update monitor as you have to also download the PowerShell module again. but aside from that it works ok. Certainly saved us some azure costs

    Mick Gray
    0
  • Jason A

    Not the answer(s) I was hoping for, but they are the answers I was expecting.

    Just one more thing I'll need to keep in mind in our slow migration to PaaS

    Thank you both!

    Jason A
    0

Add comment

Please sign in to leave a comment.