Azure SQL托管实例的修补性能 [英] Azure SQL managed instance patchy performance
问题描述
我们一直在运行使用Azure SQL托管实例的应用程序的一些性能测试. 但是，我们似乎得到了零碎的性能，在这些情况下，以前运行缓慢的查询(以前几秒钟)花费了几毫秒，而花费的时间却超过了30秒. 这些减速通常每5到10分钟发生一次. 此时，在SQL事件探查器中，它显示了许多由DmvCollector和BackupService执行的事件
We have been running some performance tests of our application that is using Azure SQL Managed Instance. However we seem to be getting patchy performance where we get slow running queries that have previously (a few seconds earlier) taken a matter of milliseconds taking longer than 30 seconds. These slowdowns usually happen every 5 – 10 minutes. At this time in the SQL Profiler it shows lots of events executed by DmvCollector and BackupService
正如以前有人在此论坛上建议的那样，我们增加了数据库和日志的磁盘大小. 现在将它们配置为257GB，以将其强制安装到P20(512 GB 2300 IOPS磁盘)上.
As someone has previously suggested on this forum, we have increased the disk size of the database and logs. They are now configured to be 257GB to force them onto a P20 (512 GB 2300 IOPS disk).
我们在
We have used the script at https://github.com/dimitri-furman/managed-instance/blob/master/MI-GP-storage-perf/MI-GP-storage-perf.sql to monitor IOPS and throughput, and don’t appear to be getting anywhere close to exceeding them.
在将生产系统迁移到Azure之前，还有其他建议可以使性能更可靠吗?
Any other suggestions to make performance more reliable before we migrate our production system to Azure?
推荐答案
Hello,
Could you try to implement the following real-time performance monitoring solution?
https://blogs.msdn.microsoft.com/sqlcat/2018/09/26/real-time-performance-monitoring-for- azure-sql-database-managed-instance/
https://blogs.msdn.microsoft.com/sqlcat/2018/09/26/real-time-performance-monitoring-for-azure-sql-database-managed-instance/
Let’s see what this monitoring solution brings to the table.
Please use the information provided by performance counters to identify performance issues.
https://github.com/dimitri -furman/managed-instance/blob/master/perf-counters/perf-counters-mi.sql
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
这篇关于Azure SQL托管实例的修补性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
