Azure sql managed instance Log generation throttle

sakuraime 2,316 Reputation points
2021-09-07T04:08:41.19+00:00

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
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
    2021-09-08T18:31:11.49+00:00

    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 Learn

    Regards,
    Oury

    0 comments
  2. Alberto Morillo 32,801 Reputation points MVP
    2021-09-08T22:16:41.577+00:00

    "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 Learn.