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_vProductAndDescriptiononce a week.- Automate Statistic Updates
Create a runbook to update statistics in
acwebevery night.- Automate Integrity Checks
Create a runbook to check the integrity of
acwebonce a week.
