Episode
Understanding Connectivity issues in SQL Database | Data Exposed
with Anna Hoffman, Subbu Kandhaswamy
The connections established to Azure SQL Database from applications or client tools may be unexpectedly terminated and impact user environments due to internal (System) maintenance work, client networking, application related or other health related issues. In this episode with Anna Hoffman and Subbu Kandhaswamy, we will cover recommended steps to identify connection failures to your database and best practices to handle these failures using resources & tools available for Azure SQL Database.
Chapters
- 00:00 - Introduction
- 00:52 - Overview
- 01:17 - Understanding the problem
- 01:38 - Azure Resource Health
- 02:14 - SQL Side of connectivity issues
- 02:45 - Handling Transient failures
- 03:54 - Demo
- 04:56 - Non-Transient failures
- 06:32 - Demo
- 08:00 - Understanding Connection timeout and Query timeout
- 08:34 - Network Connectivity issues - Dropped connections
- 09:37 - Connection Policy
- 10:01 - Communication failures
- 10:51 - Demo
- 11:41 - Conclusion & getting started
Recommended resources
The connections established to Azure SQL Database from applications or client tools may be unexpectedly terminated and impact user environments due to internal (System) maintenance work, client networking, application related or other health related issues. In this episode with Anna Hoffman and Subbu Kandhaswamy, we will cover recommended steps to identify connection failures to your database and best practices to handle these failures using resources & tools available for Azure SQL Database.
Chapters
- 00:00 - Introduction
- 00:52 - Overview
- 01:17 - Understanding the problem
- 01:38 - Azure Resource Health
- 02:14 - SQL Side of connectivity issues
- 02:45 - Handling Transient failures
- 03:54 - Demo
- 04:56 - Non-Transient failures
- 06:32 - Demo
- 08:00 - Understanding Connection timeout and Query timeout
- 08:34 - Network Connectivity issues - Dropped connections
- 09:37 - Connection Policy
- 10:01 - Communication failures
- 10:51 - Demo
- 11:41 - Conclusion & getting started
Recommended resources
Have feedback? Submit an issue here.