Use relational database as a service Fully managed
Use relational database as a service
Fully managed SQL database service that lets you focus on your business SQL • Database provisioning on-demand • Predictable performance for enterprise workloads • Elastic database pools for unpredictable Saa. S workloads • 99. 99% availability SLA • Geo-replication and restore services for data protection • Secure and compliant to protect sensitive data • Compatible with SQL Server 2016 databases
Azure SQL Database Service Features
SQL Database Service Tiers • • • •
database transaction unit Reads DTU Writes Compute Memory
P 11 P 6 B S 0 S 1 S 2 S 3 P 1 P 2 P 4
Max per-database burst level
Point-in-time restore Programmatic “oops recovery” of data deletion or alteration Auto backups, transactional logs every 5 min Backups in Azure Storage and geo-replicated Creates a side-by-side copy, non-disruptive REST API, Power. Shell or Azure Portal SQL Database Backups Azure Storage Geo- replicated sabcp 01 bl 21 Backups retention policy: • Basic, up to 7 days • Standard, up to 14 days • Premium, up to 35 days Automated export of logical backups for long -term backup protection Restore from backup sabcp 01 bl 21
Geo-restore Emergency data recovery when you need it most Available in Basic, Standard and Premium Built on geo-redundant Azure Storage Recover to any Azure region SQL Database Backups sabcp 01 bl 21 Azure Storage Geo- replicated sabcp 01 bl 21 Restore to any Azure region
Active geo-replication Mission-critical business continuity on your terms, via programmatic APIs Self-service activation in Premium Create up to 4 readable secondaries Replicate to any Azure region Automatic data replication, asynchronous REST API, Power. Shell or Azure Portal RTO<1 h, RPO<5 m, you choose when to failover Up to 4 secondary replicas
Fed. RAMP, ISO, HIPPA, PCI, EU MC, UK G-Cloud
Extensive Experience and Credentials 13
ISVs and Saa. S Enterprise Apps Serving Customer Enterprise Apps Serving Employees
- Slides: 16