Azure SQL Database Tiers
- Basic Tier: Suitable for light workloads with minimal performance demands.
- Standard Tier: Ideal for moderate workloads, providing better performance and storage options.
- Premium Tier: Designed for high-performance, IO-intensive production workloads with high availability and zero downtime.
- Serverless Compute Tier: Optimizes price-performance for databases with intermittent, unpredictable usage by auto-scaling compute and billing per second.
- Hyperscale Tier: Combines compute auto-scaling with storage auto-scaling up to 100 TB, providing scalability and performance optimization for large databases.
- General Purpose Tier: Offers balanced and predictable performance for various workloads, suitable for most applications.
- Business Critical Tier: Provides high-performance and high-availability features for mission-critical workloads, ensuring minimal downtime and data loss.
Microsoft Azure SQL Database | Complete Tutorial
Azure SQL Database is a relational database (RDBMS) service provided by Microsoft Azure that is widely used by developers when creating new applications in the cloud. It is managed completely by Microsoft and is a highly scalable platform-as-a-service (PaaS) designed especially for cloud applications. Here, we create a managed database server in the cloud and use the server to deploy our database. The server is a logical construct that acts as the central administration point for pooled databases or multiple logins, auditing rules, threat detection policy, and failover groups.
Table of Content
- Microsoft Azure SQL Database
- What is Microsoft Azure SQL Database?
- Azure SQL vs. SQL Server
- Why Azure SQL Database?
- SQL Azure Architecture
- Azure SQL Database Features
- Azure SQL Database Tiers
- Azure SQL Database Services
- Microsoft Azure SQL Database Hands-on
- Querying using Azure SQL Database
- Pricing Of Azure SQL Database
- Deleting Databases in AzureSQL
- Conclusion
- Azure SQL Database – FAQs