Post reply

Managed Instance Maintenance Plan

  • February 17, 2023 at 9:01 am

    #4150945

    Hi Experts,

    Whats the best way and what are all the maintenance plans required for Azure SQL databases & Azure Managed Instances?

     

    TIA

  • February 18, 2023 at 9:10 am

    #4151362

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • February 23, 2023 at 6:03 am

    #4153128

    Awaiting expert opinion.

  • February 23, 2023 at 9:05 am

    #4153180

    What would you usually be creating a maintenance plan to do?

     

    DBCC CHECKDB

    Database backups

    Index maintenance

     

    So doing a quick google search (other providers available) “do I need to run dbcc checkdb on azure sql database?” “do I need to run dbcc checkdb on azure sql mi?” Etc will yield you a lot of results.

     

    DBCC CHECKDB on Azure SQL DB - No

    DBCC CHECKDB on Azure SQL MI - Yes

     

    Now I don’t use any of these technologies but I do remember MIs having limitation on using maintenance plans so you need to go and use Ola’s scripts or write your own to make jobs to do the maintenance pieces you need to do.

    Azure SQL DB doesn’t have an agent so your into using alternative like elastic jobs, automation, or having an IaaS machine to kick off scripts.

     

     

    What you are asking here is well documented on the internet it will just take you some time to go and find the information you need.

  • March 2, 2023 at 8:56 am

    #4155857

    Ant-Green wrote:

    What would you usually be creating a maintenance plan to do?

    DBCC CHECKDB

    Database backups

    Index maintenance

    So doing a quick google search (other providers available) “do I need to run dbcc checkdb on azure sql database?” “do I need to run dbcc checkdb on azure sql mi?” Etc will yield you a lot of results.

    DBCC CHECKDB on Azure SQL DB - No

    DBCC CHECKDB on Azure SQL MI - Yes

    Now I don’t use any of these technologies but I do remember MIs having limitation on using maintenance plans so you need to go and use Ola’s scripts or write your own to make jobs to do the maintenance pieces you need to do.

    Azure SQL DB doesn’t have an agent so your into using alternative like elastic jobs, automation, or having an IaaS machine to kick off scripts.

    What you are asking here is well documented on the internet it will just take you some time to go and find the information you need.

     

    Thanks Ant,

    I could find much on Azure SQL MI maintenance plans especially wrt to indexes. Implemented trusted Ola's script finally.  Was wondering if there is anything in particular we need to look into when managing SQL MI both inside and outside the scope of MI.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply