Automate Maintenance on Azure SQL Databases

30 minutes
  • 3 Learning Objectives

About this Hands-on Lab

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.

Additional Resources

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.

To ensure your database is achieving peak performance, automate the following tasks:

  • Index rebuilds on acweb weekly
  • Statistics updates on acweb nightly
  • Integrity checks for acweb weekly

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?