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

Azure SQL Database
SQL