First published on MSDN on Dec 10, 2017
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.
You could customize modifying the TSQL.SQL with the queries that you want to execute and modifying the PowerShell script you could configure the server, user and password for testing the connection and execution time.
It is needed to have installed the Connector/Net: ADO.NET driver for MySQL first.
Follow up the instructions in Spanish and English
Feel free to add more options and test in this Powershell script.
Enjoy!
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.
You could customize modifying the TSQL.SQL with the queries that you want to execute and modifying the PowerShell script you could configure the server, user and password for testing the connection and execution time.
It is needed to have installed the Connector/Net: ADO.NET driver for MySQL first.
Follow up the instructions in Spanish and English
Feel free to add more options and test in this Powershell script.
Enjoy!
Updated Mar 14, 2019
Version 2.0Jose_Manuel_Jurado
Microsoft
Joined November 29, 2018
Azure Database Support Blog
Follow this blog board to get notified when there's new activity