From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Configure Azure SQL Database

Configure Azure SQL Database

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Configure Azure SQL Database

“

- Welcome back, this is lesson 2.1: Configure Azure SQL Database for scale and performance. Let's begin our discussion with Elastic Pools. Now, if you remember from our last lesson, I briefly mentioned elastic pools but didn't say much about it and you were probably going "Wait, tell me more." Well, I'm going to tell you more right now. So let's talk about elastic pools. So elastic pool, you create an elastic pool on a logical server and an elastic pool is a pool of resources, CPU and memory, and you add databases to that pool and those databases share those resources. So you create an elastic pool, that pool's made up of CPU and resources, put the databases in that pool and those databases share those resources and take as much CPU and memory as they need. Now because you pay for a pool of resources and those databases use those resources, it's much more cost-effective because you're just paying for a pool instead of paying for resources on an individual database. Optimize price…

Contents