延迟从DMZ访问Azure SQL [英] Delay with access to Azure SQL from DMZ

问题描述

Hello Everybody，

Hello Everybody,

我想请教您关于从DMZ区域和DMZ区域外部访问Azure SQL的延迟的反馈。

我的问题是我有2个虚拟机（我们称之为A和B）（标准B2ms）并且都连接到Azure SQL。

机器A在DMZ中并且有一个应用程序在Azure SQL上执行查询（大约20分钟），而机器B不在DMZ中，并且使用SSMS，它在1分钟内执行相同的查询。

我想知道问题是否可能是某些网络设置？

I would like to ask you for feedback on the delay in accessing Azure SQL from the DMZ zone and from outside the DMZ zone.
My problem is that I have 2 virtual machines (let's call them A and B) (Standard B2ms) and both connect to Azure SQL.
Machine A is in DMZ and has an application that performs a query (about 20 minutes) on Azure SQL, while machine B is not in DMZ and using the SSMS it performs the same query in 1 min.
I wonder here if the problem may be some network setting?

问候

Lukasz

推荐答案

 

Hi, 

你有防火墙吗？你传递了什么流量？

Do you have any Firewall through which you are passing the traffic?

你能告诉我两个虚拟机的流量吗？ 

Can you give me the traffic flow of both the VMs? 

您可以通过安装名为Psping的工具尝试运行以下命令，并检查VM和SQL服务器之间的延迟来自这两台机器？

Can you try running the below command by installing a tool called Psping and check the latency between VM and SQL server from both the machines?

链接：  https://docs.microsoft.com/en-us/sysinternals/downloads/psping

Link: https://docs.microsoft.com/en-us/sysinternals/downloads/psping

< span style ="font-weight：600; font-family：'Segoe UI'，SegoeUI，'Segoe WP'，'Helvetica Neue'，Helvetica，Tahoma，Arial，sans-serif; font-size：16px"> psping -s IP：1433（端口）

分享结果，我们可以把它拿走从那里。 

Share the results and we can take it from there. 

问候， 

Msrini

这篇关于延迟从DMZ访问Azure SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！