Database SQL di Azure

Azure SQL Database provides the following deployment options for an Azure SQL database

• As a single database with its own set of resources managed via a logical server
• As a pooled database in an elastic pool with a shared set of resources managed through a logical server
• As a part of a managed instance, which is a collection of databases that contains system and user databases and shares a set of resources

In general, elastic pools are designed for a typical software-as-a-service (SaaS) application pattern, where there is one database per customer or tenant. Purchasing individual databases and over-provisioning to meet the variable and peak demand for each database is often not cost efficient, but with pools, you manage the collective performance and the databases scale up and down automatically. Azure's intelligent engine recommends a pool for databases when a usage pattern warrants it. For details, see Elastic pool guidance.

SQL Database Managed Instance is an expansion of the existing SQL Database resource types, combining the best of SQL Server with all the benefits of a fully-managed (platform as a service) PaaS, minimizing or eliminating the need to re-design the application. SQL Database Managed Instance uniquely offers instance-level compatibility for SQL Server features such as SQL Agent, Service Broker, Linked Server, and cross-database queries, enabling new migration scenarios where application changes are significantly reduced or eliminated.

Azure Hybrid Benefit for SQL Server helps you maximize the value from your current licensing investments and accelerate their migration to the cloud. Azure Hybrid Benefit for SQL Server is an Azure-based benefit that enables you to use your SQL Server licenses with Software Assurance to pay a reduced rate (“base rate”) on SQL Database. Azure Hybrid Benefit for SQL Server is available at public preview of the vCore-based purchasing model for SQL Database single databases and elastic pools. You may apply this benefit even if the SKU is already active, but please note that the base rate is applied from the time you select it in the Azure portal. No credit will be issued retroactively.

No, Azure SQL Database is a fully managed database service, which means that Microsoft operates SQL Server for you and ensures its availability and performance. SQL Database also includes innovative features to enhance your security and business continuity. For example, built-in high availability. A comprehensive security portfolio allows you to implement intelligent features like threat detection, so that don’t have to worry about administering or maintaining hundreds or thousands of your SQL Server databases.

View the full feature comparison between Azure SQL Database vs. SQL Server.

This new purchasing model is an addition to the existing DTU-based model. The vCore-based model is designed to give you flexibility, control, transparency, and a straightforward way to translate on-premises workload requirements to the cloud. It also allows you to scale your compute and storage resources based on your workload needs. Single database and elastic pool options using the vCore model are also eligible for up to 55 percent savings with Azure Hybrid Benefit for SQL Server. See the vCore-based purchasing model for more information.

The vCore-based service tiers are primarily differentiated by availability, storage type, and IOPs.

• General Purpose is appropriate for most business workloads, offering a balanced set of compute and storage options where IO latency or failover times are not the priority.
• Hyperscale is optimized for OLTP and high throughput analytics workloads with highly scalable storage and read-scale requirements.
• Business Critical is best for OLTP applications with high transaction rate and lowest latency IO. It offers highest resilience to failures using several, isolated replicas.