如何最大程度地减少Azure应用服务和Azure SQL数据库之间的延迟? [英] how to minimize latency between Azure App Service and Azure SQL Database?
问题描述
此App Service应用程序已连接到同样属于美国西部弹性组的SQL数据库服务，该服务组的服务计划为Standard 1200 eDTU.
我们通过在App Service上调用RESTful WebService进行测试，该服务应在数据库的2个表上插入50条记录，总共插入100条记录.完成此任务需要3000毫秒.
如果我们在与Tomcat服务器相同的本地计算机上运行SQL Server的本地计算机上对Restful WebService的相同调用，则该任务将在400毫秒内完成.
所以这就是为什么我问我，我对天青技术还很陌生，也许我们可以采取其他选择来在服务器之间提供更好的通信，或者我不知道有什么方法可以调试此问题.
解决方案
Daniel，数据中心内部通信应该非常快.请注意，尽管我们不保证此类指标会达到特定的性能水平.
话虽这么说，您是否将应用程序服务或SQL DB连接到VNET?
We have an Azure App Service application using Java Tomcat 8.5 running in West US Region. The Service Plan for this Service is Standard, Big.
This App Service application is connected to a SQL Database Service that belongs to an Elastic Group also in West US which Service Plan is Standard 1200 eDTU.
The problem we are facing is a very poor performance between the interaction of both servers.
We have been testing by calling a RESTful WebService on the App Service that should insert 50 records on 2 tables on the database.Total 100 records inserted. For doing this task it takes 3000 ms.
We have been measure this by saving timestamps between starting inserting process, and ending insert. So no time from local client to app service communication is included.
If we run the same call to Restful WebService on local machine with SQL Database running on the same local machine as the Tomcat Server, the task was completed in 400 ms.
So I'm intend to think that the problem should be the latency of the connection between this two servers on the azure cloud or maybe I was missing something here.
So that's why I'm asking, I'm pretty new to azure technology and maybe there is other options we can take to provide a better communication between the servers or there is a way I don't know to debug this problem.
As a side question if this 2 server where inside of my own datacenter I will make sure it will communicate directly on its own network, not sure if that king of service is available in azure at the moment.
Daniel, intra-datacenter communication should be extremely quick. Do note though that we do not promise a particular level of performance on this type of metric.
With that being said, do you have your app service or SQL DB connected to a VNET?
这篇关于如何最大程度地减少Azure应用服务和Azure SQL数据库之间的延迟?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
