Blog Post

Azure Database Support Blog
1 MIN READ

Lesson Learned #187: How to measure the connection latency in Azure SQL DB/Managed Instance

Jose_Manuel_Jurado's avatar
Feb 24, 2022

We often receive service requests where our customers asked about how to improve/measure the connection between my application and Azure SQL Database and/or Azure SQL Managed Instance, in this new post, I would like to share with you some of them. 

 

Best Practices

 

 

How the measure the latency

 

  • In this github you could find a useful information about how to measure the connection latency for your database, for example, the PowerShell script called SQLConnectivityTest.ps1. Running this you are going to have a very useful information about the latency for multiple performance counters that be part of a connection/execution: ConnectionTime, ExecutionTime, NetworkServerTime based on this URL

 

Enjoy!

Published Feb 24, 2022
Version 1.0
No CommentsBe the first to comment