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

Schedule monitoring of Azure SQL DB serverless databases

We have a few serverless Azure SQL databases that automatically pause after 1 hour of inactivity. However SQL monitor seems to keep them awake.

Is there anyway that we could automatically schedule SQL monitor to stop monitoring selected databases outside of office hours so they can pause (and we can save some money!)
Severn
0

Comments

2 comments

Sort by
  • Robyn
    Hi,

    Thanks for your post.

    As SQL Monitor licensing for Azure SQL Databases is per database, it makes no difference if it's a serverless database or not. 
     
    You can use the Powershell API and create a script that suspends and unsuspends those databases at a set time. 
    Robyn
    0
  • Severn
    Thanks Robyn, I wasn't aware I could do that and, what's more, that there were examples in the configuration menu!
    Have found an example that does just what I want and will give it a go.
    Severn
    0

Add comment

Please sign in to leave a comment.