Azure Manage Instance low performance than Azure SQl VM

prashyuth 1 Reputation point
2021-02-23T03:21:08.953+00:00

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.

SQL Server on Azure Virtual Machines
Azure SQL Database
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
503 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Anshul Farkya 131 Reputation points
    2021-02-23T11:09:06.01+00:00

    Please verify your MAXDOP settings and Cost threshold for parallelism on managed instance with your VM configuration.

    Best Regards,
    Anshul