Lesson Learned #31: How to measure a TSQL execution time against Azure Database for MySQL

Often, our customers asked about the connection latency or execution time of a query between their servers and their Azure Database for MySQL. Trying to identify what is the time spent in each step I created this PowerShell Script called SQLMySQLConnectivityTest.ps1 that in based on SHOW PROFILE ALL results shows the time spent in different steps of the query….


Lesson Learned #30: How to measure a TSQL execution time against Azure SQL Database

Very often, our customers asked about the connection latency or execution time of a query between their servers and their Azure SQL Database. Trying to identify what is the time spent in each step I created this PowerShell Script that measures several counters like Network Server Time, Execution time, Connection Time, etc.. based on the statistics data…