question

sakuraime avatar image
0 Votes"
sakuraime asked OuryBa-MSFT commented

Azure sql managed instance Log generation throttle

in Azure SQL managed instance , sometimes I see their are some log generation throttling on the os_wait_stats , or from exec_request wait .
how to get rid of it except by upgrade to high tier ?
Is it there is a build in resource governor for that ? Can we disabled it ?

below is the reference
https://azure.microsoft.com/en-us/blog/key-causes-of-performance-differences-between-sql-managed-instance-and-sql-server/

129772-testingsss.jpg





And also , create a database under Azure sql mi with a larger size will help to increase the performance ,,, on Business Critical tier

azure-sql-database
testingsss.jpg (145.9 KiB)
5 |1600 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.

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered

Hi @sakuraime From the hardware configuration perspective, this section showcases the limits and if/how they can be adjusted: Resource limits - Azure SQL Managed Instance | Microsoft Docs

Regards,
Oury

5 |1600 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.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered OuryBa-MSFT commented

"Unfortunately, there are no corrective actions that you can do to prevent this issue. Limit on the log rate is the price that must be taken to always ensure that the backups are taken.
If you are migrating your databases from SQL Server to Managed Instance you can repeat this experiment on your SQL Server instance to check what are the instance log limits that you have and could your workload run on the Managed Instance with the same performance. Just make sure that you are using the version built for your version of SQL Server."

Source: Log rate throughput cap on Managed Instance.

Jovan was part of the team that brought to live Managed Instance although he is no longer serving in that team, for me he is the must trusted source about Managed Instance even over Microsoft Docs.




· 1
5 |1600 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.

@sakuraime Please let us know if the above answers were helpful. Feel free to reach out if you have additional queries.

Regards,
Oury

0 Votes 0 ·