SQLug.se - Ronen Ariely, Azure SQL Database Elastic Pools 2018-05-31

Azure Elastic Databases & Azure Elastic Jobs
A single Azure SQL Database gets dedicated resources within a service tier at a specific performance level. These resources are available in terms of Database Transaction Units (DTUs), which determine the CPU, Memory, and the read-write rates that are available to use. The cost of each database is predefined according to the service tier and resources we choose, even if we do not use full advantage of them.
Azure SQL Database Elastic Pool is a simple solution for managing and scaling multiple Azure SQL Databases as a group. All the Databases in a pool share a set of number resources. Resources available in terms of elastic Database Transaction Units (eDTUs). It's a powerful and a cost-effective option for databases that have varying and unpredictable usage demands.
Using elastic pool, management tasks are simplified by running scripts in elastic jobs, which enables us to execute Transact-SQL scripts across a group of databases. Elastic Database jobs allow us to aggregate data from a collection of Azure SQL Databases into a single destination table/report. It improves performance by reducing the overhead of connecting to each database separately.
During the meetup, we will review the features “Azure Elastic Pools” and “Azure Elastic Database jobs”. We will discuss cases in which can be optimized by using these features, and we will demonstrate how to create & manage Azure Elastic Pool, manage multiple databases inside a pool as individual or as a group, and a quick demonstrate of using of Elastic Database.
Join the meeting to discuss and learn how to improve performance and reduce the cost of your Azure databases.
Ronen Ariely
Ronen Ariely is a senior consultant and architect, in the fields of data platform and application development. He has more than 15 years' experience in variety programming languages and technologies, leading development teams, and software companies, SQL & BI enterprise level solutions. Ronen is active in communities (aka pituach) in the field of Programming, SQL Server, and T-SQL. He serves as Moderator at MSDN and as one of the Microsoft TechNet WIKI communities' leaders. Ronen writes technical blogs, TechNet articles and blogs, and has been awarded as a Microsoft Most Valuable Professional.