Azure SQL Database Scaling in and Scaling out

Azure SQL Database – Scaling in and Scaling out with elastic pool

Agenda § What is Clour Computing? § About SQL DB § Service Tiers § Elasticity

Vitor Fava § MVP Data Platform § Pass Chapter Leader do SQLManiacs § SQL Server Database Consultant na Pythian § CEO da Vita Database Solutions § vitortff@gmail. com § http: //vfava. worpress. com § http: //www. youtube. com/vitortff § https: //groups. google. com/group/sqlmaniacs 3

What is Cloud Computing? § What is the cloud? Where is the cloud? Are we in the cloud now? § Cloud computing means storing and accessing data and programs over the Internet instead of your computer's hard drive. § Software-as-a-Service (Saa. S) § Infrastructure-as-a-service (Iaa. S) § Platform-as-a-Service (Paa. S) 4

What is Cloud Computing? 5

What is Cloud Computing? 6

What is SQL Database? § Relational database service in the cloud based on the marketleading Microsoft SQL Server engine, with mission-critical capabilities. § Delivers predictable performance, scalability with no downtime, business continuity and data protection—all with near-zero administration § Focus on rapid app development and accelerating your time to market, rather than managing virtual machines and infrastructure. § Because it’s based on the SQL Server engine, SQL Database supports existing SQL Server tools, libraries and APIs, which makes it easier for you to move and extend to the cloud. 7

Azure – Service Tiers 8

What is an Azure elastic database pool? § Provide a simple cost effective solution to manage the performance goals for multiple databases that have widely varying and unpredictable usage. § Elastic database pools ensure that databases get the performance resources they need, when they need it, while providing a simple resource allocation mechanism within a predictable budget § Advantage of all of the underlying database as a service capabilities that are built into it: § 99. 99% SLA, § multiple-high availability replica support built-in with no extra charges, § no down-time during patching, § geo-replication, § point-in-time recovery, § TDE encryption of data, § row-level security, § full-text search, 9

What is an Azure elastic database pool? § POOL e. DTU - dictates the allocation of capacity (in terms of e. DTUs) on the pool level. This should be determined based on the average utilization levels of all databases that belong to the pool. § e. DTU MIN - guarantees minimum transactional throughput (in terms of e. DTUs) for every database in the pool (you can choose not to provide any guarantees by setting this value to 0). § e. DTU MAX - ensures that individual databases in the pool are able to gracefully handle peaks in resource demand, while minimizing impact on other databases sharing the same pool and without excessive over-provisioning. 10

Elastic Pool Limits 11

Which databases go in a pool? § Databases that are great candidates for elastic database pools typically have periods of activity and other periods of inactivity. § Databases with varying activity over time are great candidates for elastic pools because they are not all active at the same time and can share e. DTUs. § Databases that have a more constant resource demand are better suited to the Basic, Standard, and Premium service tiers where resources are individually assigned. 12

Which databases go in a pool? 13

Which databases go in a pool? 14

Which databases go in a pool? 15

Pool sizing recommendations § Pools enable the developer to purchase elastic Database Transaction Units (e. DTUs) for a pool shared by multiple databases to accommodate unpredictable periods of usage by individual databases § SQL Database automatically evaluates the historical resource usage of databases in an existing SQL Database server and recommends the appropriate pool configuration in the Azure portal 16

IT’S DEMO TIME!!!!! 17

Thank You! Vitor Fava @sqlservermaniac