sql server latency

Question

Hi All,

Do we have PowerShell script or something which can capture time to establish connection towards sql server?

We have an aws application which is taking more time connecting to sql server after migrating sql vm to azure. connection towards onprem is 5 times faster than its towards azure.

CPU\Network\Disks are fine in sql server.

Regards,
ACDBA

Answer 1

Hello @ACDBA

Welcome to Microsoft Q&A Platform,

You can check the time it takes to connect including the app response time via curl (Linux), as it follows:

while :; printf '%(%H:%M:%S)T - '; do curl -o /dev/null -s -w 'Time Connect: %{time_connect} ; time_appconnect: %{time_appconnect} ;Time Total: %{time_total}\n'  "http://8.8.8.8:443" -d {} -H 'content-type:application/json'; sleep 2; done  

Or you can use psping for Windows:

psping -t -w 0 8.8.8.8:443 |  
  % { $result=("{0} - {1}" -f (Get-Date), $_) |  
    Select-String connecting  
    $result  
  }  

I hope this helps!

----------

Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

I am not familiar with browser tools to measure the network latency, you may want to check the article below about other tools, if using the console is not appropriate for you:

https://www.comparitech.com/net-admin/network-latency-testing-tools/

What about a simple ping or tracert test?

Best regards

----------

Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.