Basic tier Premium tier 99 99 Uptime SLA
Basic tier Premium tier 99. 99% Uptime SLA Predictable Performance Standard tier B S 0, S 1 or S 2 P 1, P 2 or P 3 Transactions per hour Transactions per minute Transactions per second Database size limit 2 GB 250 GB 500 GB Point In Time Restore (“oops” recovery) Any point <7 days Any point <14 days Any point <35 days Geo-Restore (restore last daily backup to another region) RTO<24 h*, RPO<24 h Standard geo-replication (offline secondary, fixed DR pairing) Not included RTO<2 h RPO<30 m Active geo-replication (up to 4 online secondaries, configurable regions) Not included RTO<1 h, RPO<5 m * Target only, actual time depends on the data size and scale of restores
Azure SQL Database Customer (subscription owner)
Single Logical Database • ü ü ü DB Ack Read Value Write P S P Ack S Write Ack Write S Reads are completed at the primary Writes are replicated to secondaries P S S
RA-GRS sabcp 01 bl 21 sabcp 02 bl 21 sabcp 03 bl 21 Copy backups to Azure Storage LS XYZ DB Backups DB 1 Backups Restore as a new database from local backups
RA-GRS sabcp 01 bl 21 US West sabcp 02 bl 21 RA-GRS Storage geo - replication sabcp 03 bl 21 sabcp 01 bl 21 sabcp 02 bl 21 sabcp 03 bl 21 LS ABC Restore to any server when needed • • • LS XYZ DB Self-service restore API US West Restores last daily backup No extra cost, no capacity guarantee RTO>=24 h, RPO=24 h Database URL will change after restore Automatic copies of daily backups DB US East
LS OPQ DB LS ABC Failover and activation of secondary (during incident) • • • Geo-r eplica DB tion North Central US LS XYZ DB West US RTO<2 h, RPO<30 m REST and Power. Shell API to opt-in and failover Automatic data replication and synchronization DMV+REST to monitor and guide failover decisions Single offline secondary with matching performance level in the DR paired region East US
North Central US n tio a lic p re DB 1 eo G Failover and activation of secondary (any time) LS DFE Ge n ore pl LS XYZ ica tio n io at lic tion. Geo a c li p re o e G p -re LS OPQ DB 1. old DB 1 LS ABC • • • West US RTO<1 h, RPO<5 m REST and Power. Shell API to opt-in and failover DMV+REST to monitor and guide failover decisions Automatic data replication and synchronization Up to 4 online secondary databases with matching performance level in any region DB 1 East US South Central US
Audit log Azure Storage SQL Database Auditing Application data
Signup to Auditing Preview Get started with Auditing in Azure SQL DB Auditing in Azure SQL Database Download Excel Template
microsoft. com/sqlserver and Amazon Kindle Store microsoftvirtualacademy. com Azure Machine Learning, Document. DB, and Stream Analytics
http: //channel 9. msdn. com/Events/Tech. Ed www. microsoft. com/learning http: //microsoft. com/technet http: //developer. microsoft. com
- Slides: 26