O'Reilly logo

Microsoft Azure Development Cookbook Second Edition by Neil Mackenzie, Roberto Freato

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required