Microsoft Azure for Developers by John Adams

Author:John Adams
Language: eng
Format: mobi, epub
Publisher: O'Reilly Media, Inc.
Published: 2015-05-22T04:00:00+00:00

SQL database

Even though NoSQL database systems are exciting and new, relational database systems are still important and relevant for most applications. Azure SQL Database is a managed database service that supports the majority of SQL Server functionality, including database programmability, SQL Server Management Studio, and the familiar T-SQL operations you are used to. Unlike SQL Server on a virtual machine, however, Azure SQL Database supports elastic scale, geo-replication, and point-in-time restore; it is automatically replicated, security patched, and has a guaranteed service-level agreement (SLA). You can scale your throughput up and down as needed to balance cost and performance.

Azure SQL Database was formerly known as SQL Azure and was initially offered as a more basic SQL service with price based on database size. The original implementation of this service lacked some common features, did not perform as well as many expected, and got a bad reputation in some circles. Things have changed, however, and with the guaranteed throughput units and service tiers now available this service is well worth your consideration and production use. In fact, having all of the database management tasks taken care of as a service makes this an attractive option for nearly any application.

Database throughput units (DTUs) are based on a blended measure of CPU, memory, reads, and writes. These units are a bit hard to describe, but they are accurately relative to one another: 10 units will offer exactly twice the performance of 5 units. See the following two tables for more details on real-world performance.

The SQL Database performance tiers are each designed around certain levels of precise, predictable throughput. The Standard tier is designed for a predictable amount of performance in transactions per minute. The Premium tier is designed for a predictable amount of performance in transactions per second. This level of guaranteed performance is impressive and allows you to develop your application knowing you can count on the level of performance that you need.

Table 1-12. SQL Database tiers and pricing Tier Throughput Size Restore period

B 5 units 2 GB 7 days

S0 10 units 250 GB 14 days

S1 20 units 250 GB 14 days

S2 50 units 250 GB 14 days

S3 100 units 250 GB 14 days

P1 125 units 500 GB 35 days

P2 250 units 500 GB 35 days

P3 1,000 units 500 GB 35 days

Table 1-13. SQL Database throughput unit examples Tier DTUs Max threads Max sessions Transactions

Basic 5 30 300 16,600/hour

S0 10 60 600 521/minute

S1 20 90 900 934/minute

S2 50 120 1,200 2,570/minute

S3 100 200 2,400 5,100/minute

P1 125 200 2,400

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.