Dive deep into Azure SQL Hyperscale in this comprehensive 46-minute video tutorial. Explore the architecture, components, and features of this powerful database solution, suitable for a wide range of SQL workloads. Learn about the Log Service, Page Servers, database storage scaling, caching mechanisms, and compute scaling options. Discover the benefits of provisioned vCores, serverless computing, and replica management. Examine geo-replication capabilities, elastic pools, and isolation features. Gain insights into pricing models and the immense scalability offered by Azure SQL Hyperscale. Understand why this solution is not just for massive databases but can be an excellent choice for various SQL implementations.
Azure SQL Hyperscale Deep Dive - Not Just for Massive Databases
John Savill's Technical Training via YouTube
Overview
Syllabus
- Introduction
- Regular SQL architecture
- SQL Hyperscale architecture
- Components
- Log Service
- Page Servers
- Database storage scale
- Cache
- Compute scale
- Provisioned vCores
- Scaling the vCores
- Serverless
- Replicas
- Named replicas
- Geo-replication
- Elastic pool
- Per DB min and max vCore
- Isolation
- Scaling elastic pool
- You don't need to know any of this
- Pricing
- Huge scale flexibility
- Other names
- Close
Taught by
John Savill's Technical Training
