Lesson Learned #240: Checking connection and execution latency in Azure SQL DB and Managed Instance
Today, I worked on a service request that our customer asks about: How to know the connection time invested to connect to the database in Azure SQL Database and Azure SQL Managed Instance. How to know the time invested running a real queries to know the latency of the network, roundtrips and execution time. Following, I would like to share a small PowerShell Script that giving some parameters your could know by your own these numbers. All this information is based on this article
