Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 172 of 212

160 C H A P T E R 8 | Improved Azure SQL Database Understanding the pricing model SQL Database is available as an Azure pay-as-you-go service, as it has been since its introduction. At that time, you set up your database by specifying either Web or Business edition, for which a flat per- month fee was assessed. Just as the feature set for SQL Database has evolved over time, the pricing model has evolved so that you have a wider set of options from which to choose. When you create a new SQL Database, you now select a service tier and performance level to allocate resources. Your monthly cost is calculated based on your choice of service tier and performance level, in addition to the number of hours of usage and the number of standard or active geo-replication secondary databases established, when applicable. Note For more information about the factors influencing the monthly cost of SQL Database, see Service tiers SQL Database service tiers support different types of workloads and throughput levels. It currently includes the following service tiers: Basic Supports a database up to 2 GB for a small application with a light transactional workload and relational requirements. The benchmark transaction rate is 16,600 transactions per hour. Standard Supports a database up to 250 GB for a normal to midsize application requiring midlevel performance with built-in high availability. Performance is measured as transactions per minute, with a benchmark of 2,570 for the S2 performance level. Premium Supports a database up to 1 TB for a top-tier, mission-critical database requiring the highest level of performance and availability. Its benchmark transaction rate is 735 transactions per second at the P3 performance level. Note Each tier is guaranteed basic availability. However, the Standard and Premium service tiers offer online secondary replicas in other Azure regions, with the Premium service tier offering active secondary replicas. Performance levels The unit of measurement for a performance level is a Database Throughput Unit (DTU). It represents a blend of CPU, memory, and read and write metrics related to the server resources allocated to your database. A database with 10 DTUs has twice the server resources of a database with 5 DTUs. Each performance level has a different range of DTUs available and different transactions rates, as shown in the following table. Service tier Performance level DTUs Benchmark transaction rate Basic N/A 5 16,600 transactions per hour Standard S0 10 521 transactions per minute S1 20 934 transactions per minute S2 50 2,570 transactions per minute

Articles in this issue

Links on this page

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016