Automating Azure SQL Database index maintenance

Vijay Kumar 2,016 Reputation points
2020-10-16T20:39:37.65+00:00

Hi,

I am planning to implement Automating index maintenance on Azure SQL Database.

What is the best approach and ways to implement?

there are 10 DB's.

Azure SQL Database
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,157 questions
{count} votes

Accepted answer
  1. Mike Ubezzi 2,776 Reputation points
    2020-10-17T03:23:27.87+00:00

    Hi, @Vijay Kumar - Please take a look at the following TechCommunity blog specific to your ask: Automating Azure SQL DB index and statistics maintenance using Azure Automation

    The general steps are the following where the blog has the detailed steps:

    1. Azure automation account
    2. Import SQLServer module
    3. Add Credentials to access SQL DB
    4. Add a runbook to run the maintenance
    5. Schedule task

    Please let the forum know if you have any additional questions or need assistance deploying solution detailed in the document.


0 additional answers

Sort by: Most helpful