Blog Post

Azure Database Support Blog
1 MIN READ

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

Jose_Manuel_Jurado's avatar
Mar 14, 2019
First published on MSDN on Dec 10, 2017
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 obtained from the function RetrieveStatistics of SQLClient.SQLConnection

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.

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.0
No CommentsBe the first to comment