SQL Managed Instance Accelerated Database Recovery
-
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.
-
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
-
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply