Post reply

SQL Managed Instance Accelerated Database Recovery

  • May 8, 2023 at 2:54 pm

    #4186135

    ADR feature is optional in Onpremise where as in SQL ManagedInstance, it is enabled by default.

    In the Below link performance comparison has been done by Niko Neugebauer. There's about 8% decrease in the performance for Insert/Update/Delete, when ADR is enabled.

    https://www.nikoport.com/2019/09/18/accelerated-database-recovery/

    so there will be atleast 8% performance degradation if we migrate to Azure SQL MI, adding IOPS/throughput for PVS file, it could be more ?

    Also are there any other features that could degrade the performance in Managed Instance, which doesnt exist for Onpremise.

  • May 9, 2023 at 3:10 pm

    #4186705

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

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

  • May 9, 2023 at 5:02 pm

    #4186785

    I can "azure you" that I can't answer your question because I've never used Azure before. 😀

    I just want to say "Thank you" for the link to what looks like a great article and I'm going to check it out.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 2 (of 2 total)

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