Azure SQL Database - Platform as a Service
Azure SQL Database is a fully managed Platform as a Service (PaaS) Database Engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of SQL Server Database Engine and patched OS with 99.99% availability. PaaS capabilities that are built-in into Azure SQL database enable you to focus on the domain specific database administration and optimization activities that are critical for your business.
Azure SQL Database enables your business to continue operating in the face of disruption, particularly to its computing infrastructure.
Azure SQL Database guarantees that your databases are up and running 99.99% of time, without worrying about maintenance and downtimes.
Azure SQL Database automatically creates database backups and uses Azure read-access geo-redundant storage (RA-GRS) to provide geo-redundancy.
Long term backup retention
Azure SQL Database enables you store specified SQL database full backups for up to 10 years.
Azure SQL Database enables you to create readable replicas of your database in the same or different data center (region).
Azure SQL Database enables you to easily add more resources (CPU, memory, storage) without long provisioning.
Azure SQL Database provides a set of additional built-in PaaS features that you can use to more easily manage your databases.
- Advanced security detects threats and vulnerabilities in your databases and enables you to secure your data.
- Automatic tuning analyzes your workload and provides you the recommendations that can optimize performance of your applications by adding indexes, removing unused indexes, and automatically fixing the query plan issues.
- Built-in monitoring capabilities enable you to get the insights into performance of your databases and workload, and troubleshoot the performance issues.
- Built-in intelligence automatically identifies the potential issues in your workload and provides you the recommendations that can help you to fix the problems.