We often have support cases where our customers need to know the difference between a connectivity and an execution timeout. In this video we are going to explain what an execution timeout is, how it differs from a connection timeout, how to reproduce it and how to detect it in order to apply a solution to it.
We will review in this video standard and adhoc tools and the features that Azure portal provides us to detect it.
References:
- Lesson Learned #1: Capturing a TSQL Command Timeout - Microsoft Tech Community
- Lesson Learned #195: Performance Best Practices for Azure SQL Database and Managed Instance. - Microsoft Tech Community
- Lesson Learned #196: Latency and execution time in Azure SQL Database and Azure SQL Managed Instance - Microsoft Tech Community
Enjoy!
Updated Apr 30, 2022
Version 2.0
Jose_Manuel_Jurado
Microsoft
Microsoft
