In this hands-on lab scenario, your organization, Awesome Company, is reducing its on-site footprint and moving as many databases as possible to the cloud. As part of this effort, you have already migrated one of your primary sales databases, `acweb`, to Azure SQL Database. As the utilization of this database increases, you need to implement database maintenance tasks to keep it running in top condition. However, performing these tasks manually is more error-prone and less time-efficient. You need to automate its routine maintenance tasks. Performing the actions of this lab will help you become familiar with using Azure Automation service to implement maintenance tasks against Azure SQL Database.
Learning Objectives
Successfully complete this lab by achieving the following learning objectives:
- Automate Index Rebuilds
Create a runbook to rebuild the frequently fragmented index
IX_vProductAndDescription
once a week.- Automate Statistic Updates
Create a runbook to update statistics in
acweb
every night.- Automate Integrity Checks
Create a runbook to check the integrity of
acweb
once a week.