Understanding Connectivity issues in SQL Database | Data Exposed

From the creator

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. 0: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 ✔️Resources: Troubleshoot common errors: https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql Resource health: https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-health-to-troubleshoot-connectivity?view=azuresql Connectivity Architecture: https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql Azure SQL Connectivity Checker tool: https://github.com/Azure/SQL-Connectivity-Checker 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna T

Published 2022-12-08 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.