Add scheduling for monitoring suspension and resumption
Using Azure SQL Database in serverless mode with an auto-pause is a useful feature to save money when the db is not in use. SQL Monitor keeps the db from sleeping overnight.
Suggest addition of scheduling for Suspend/Resume operations, similar to alert suppression scheduling.
3
votes
Si mon
shared this idea
Hi, you should be able to use the SQL Monitor API (see https://documentation.red-gate.com/sm/api) to schedule suspending/resuming monitoring for your Azure SQL Databases.