question

prashyuth-8640 avatar image
0 Votes"
prashyuth-8640 asked ·

Azure Manage Instance low performance than Azure SQl VM

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.

azure-sql-databaseazure-sql-virtual-machinessql-server-migration
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@prashyuth-8640 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

0 Votes 0 ·

1 Answer

AnshulFarkya-7260 avatar image
0 Votes"
AnshulFarkya-7260 answered ·

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

Best Regards,
Anshul

· 4 · Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@AnshulFarkya-7260 , I have verified both the settings are the same as VM. 5 and 0 respectively.

0 Votes 0 ·

Compare the query plans of the problem UPDATE statement and check for blocking.

0 Votes 0 ·

No Luck Bro, There is no block and the update statement plan seems the same.

0 Votes 0 ·
Show more comments