Azure SQL和IaaS之间的性能不佳 [英] Bad performance between Azure SQL and IaaS

问题描述

我当前的设置如下所示.
VM D8s V3(IaaS)
Azure SQL(Premium 250eDTU)

My current setup looks like this.
VM D8s V3 (IaaS)
Azure SQL (Premium 250eDTU)

推荐答案

性能永远不会与本地数据库相同，您必须应对两者之间的网络连接.您没有提及查询将返回多少数据，因此尚不清楚这将为您带来多少问题.我建议 您首先看一下数据传输占用了多少时间.

Performance is never going to be the same as a local database, you have to contend with network connectivity between the two. You make no mention of how much data your query is returning so it's not clear how much of an issue this will be for you. I suggest you first look at how much of that time is being taken up with data transport.

其次，Azure SQL将更加严格地限制您选择要部署的SKU的限制.使用SQL Express，它将可以访问本地框的所有资源.现在，您说您在SQL框中仅命中了40％的DTU，但是DTU 不是一切.

Secondly, Azure SQL is going to be much tighter on restricting you to the limits of the SKU you choose to deploy. With SQL express it will have access to all the resources of the local box. Now you say that your only hitting 40% DTU on the SQL box, but DTU is not everything.

这篇关于Azure SQL和IaaS之间的性能不佳的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！