Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Understanding Connectivity issues in SQL Database | Data Exposed

Microsoft Developer
589K subscribers
<__slot-el>
<__slot-el>
3.3K views 2 years ago #SQLServer #Connectivity #AzureSQL
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 commo …...more
...more
Understanding Connectivity issues in SQL Database | Data Exposed
71Likes
3,301Views
2022Dec 8
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/azu... Resource health: https://learn.microsoft.com/en-us/azu... Connectivity Architecture: https://learn.microsoft.com/en-us/azu... Azure SQL Connectivity Checker tool: https://github.com/Azure/SQL-Connecti... 📌 Let's connect: Twitter: Anna Hoffman,   / analyticanna   Twitter: AzureSQL, https://aka.ms/azuresqltw​​​​ 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #SQLServer #AzureSQL #AzureSQLDatabase #Connectivity

Follow along using the transcript.

Microsoft Developer

589K subscribers