This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 53%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hi, We have a 16 Core Azure Manage Instance SQL, Queries are running very slow compared to Azure SQL VM. Example update statement of a table consists of 35 lakhs table is taking 12 Minutes whereas 8 Core SQL Vm is taking only just 0 seconds to complete the same statement. In MI the usage of the server is hardly 20 % but still, our queries are taking longer than that.
@prashyuth Any update on the issue?
Please "Accept as Answer" if it helped you so it can help others in community looking for help on similar topics.
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 30%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Please verify your MAXDOP settings and Cost threshold for parallelism on managed instance with your VM configuration.
Best Regards,
Anshul
@Anonymous , I have verified both the settings are the same as VM. 5 and 0 respectively.
Compare the query plans of the problem UPDATE statement and check for blocking.
No Luck Bro, There is no block and the update statement plan seems the same.
Upload the actual plans here and add the links to your question. For such a large difference in execution times without resource contention, I would expect some difference, even if not obvious at first glance.