Handling connection failures to a SQL Database
The Azure SQL Database is a distributed system in which each server hosts many databases. This sharing of resources leads to capacity constraints on operational throughput. The SQL Database handles these capacity constraints by throttling operations and closing connections that are using too many resources. SQL Database also closes connections when it alleviates operational hot spots by switching from a primary SQL Database to one of its two backup copies. Furthermore, connectivity to a SQL Database is likely to be less reliable than connectivity to a Microsoft SQL Server database on a corporate LAN. It is imperative, therefore, that applications using the SQL Database must be designed to withstand ...
Get Microsoft Azure Development Cookbook Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
