问题描述
我们一直在运行使用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).
我们在 https://github.com/dimitri-furman/managed-instance/blob/master/MI-GP-storage-perf/MI-GP-storage中使用了脚本-perf.sql 来监视IOPS和吞吐量，并且似乎没有什么可以超过它们的.
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?
推荐答案
您可以尝试实施以下实时性能监控解决方案吗?
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/
让我们看看这个监控解决方案带来了什么.
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,
阿尔贝托·莫里洛
SQLCoffee.com
Alberto Morillo
SQLCoffee.com
这篇关于Azure SQL托管实例的修补性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！