Scale and Pause or Resume using scheduled autoscaling

Dynamically scaling SQL PaaS elastic pool DB

https://docs.microsoft.com/en-us/azure/sql-database/scripts/sql-database-monitor-and-scale-pool-powershell

 Azure Analysis Services – Scale and Pause or Resume using scheduled autoscaling

https://gallery.technet.microsoft.com/scriptcenter/Scale-and-Pause-or-Resume-54ce97a2

Auto-archival using Elastic Jobs or Azure Automation

Example Azure Automation: https://gallery.technet.microsoft.com/scriptcenter/Azure-Automation-Your-SQL-30f8736b

Also relevant to multi-tenant application and pool of databases (tenant per DB) , you want a single automated job to run across all DBs to monitor the table size and truncate the data as needed.

Example on getting started with Elastic Jobs: https://gallery.technet.microsoft.com/scriptcenter/Automating-management-of-e7c15e2f

Leave a Reply

Your email address will not be published. Required fields are marked *