Azure SQL Datbase types (PAAS)
- Azure SQL Database (PAAS) has three flavors
- Elastic database pools
- Single Database
- Managed Instances
- Elastic database pool:
- These are greate solution for managing multiple databases and scaling their performances according the database’s needs.
- It means its a good fit for databases with unpredicatable usage demands
- Creating elastic database pool steps:
- Add the sql server firewall rule. Try connecting to database
- Now lets add one more database to elastic pool
- This database will not have extra cost as we are adding to existing pool
- Single Databases:
- This is a good fit for a set of databases with predicatable performances, where the required resources of databases are predetermined
- Managed Instance:
- Azure SQL does not offer some of the SQL Server Enterprise features
- CLR Types
- Extended stored procedures and table partitioning
- Database Mirroring and failover clustering
- Master Data services
- Attaching a database
- SQL Server agents
- Resource governer etc
- Managed is a PAAS offerings which allows you run SQL Server with all the features of Microsoft SQL Server in the Enterprise without needing to manage windows vm.
- The main use case where this offering is used is
- when your organization is migrating SQL Server Enterprise to run on AZure with all the SQL Server functionalities
- Creating SQL Server Managed Instance
- Azure SQL does not offer some of the SQL Server Enterprise features
- The next set of actions we will be discussing in the next session where we understand pricing models
- DTU
- vCore Based