Azure SQL Hyperscale Revealed: High-performance Scalable Solutions for Critical Data Workloads

The Azure SQL Database Hyperscale Service Tier is a new cloud architecture from Microsoft that supports massive databases. It horizontally scales architecture, formerly code-named Socrates, allowing you to decouple compute nodes from storage layers, dramatically increasing scalability. This book teaches how to leverage Hyperscale to provide next-level scalability, high throughput, and fast performance from large databases in your environment, eliminating many of the problems of traditional high-availability and disaster recovery architecture. It also covers migrating your current workloads from traditional architecture to Azure SQL Hyperscale.

Format: Paperback / softback
Length: 472 pages
Publication date: 22 March 2023
Publisher: APress

The Azure SQL Database Hyperscale Service Tier is a revolutionary cloud architecture from Microsoft that supports massive databases. It introduces a horizontally scalable architecture, formerly code-named Socrates, which allows you to decouple compute nodes from storage layers, significantly increasing the scalability of the service. This book will guide you on how to leverage Hyperscale to achieve next-level scalability, high throughput, and fast performance from large databases in your environment.

The book begins by showcasing how Hyperscale addresses the challenges of traditional high-availability and disaster recovery architecture. It explains how Hyperscale overcomes storage capacity limitations, reduces scale-up times and costs, and enables you to manage more data at a lower cost. You will learn how to deploy, configure, and monitor an Azure SQL Hyperscale database in a production environment, as well as how to migrate your current workloads from traditional architecture to Azure SQL Hyperscale.

Throughout the book, you will gain a deep understanding of the advantages of Hyperscale over traditional architecture. You will learn how to deploy a Hyperscale database on the Azure cloud interactively and with code, configure advanced features such as automatic tuning and resource governance, and monitor and scale database performance to suit your specific needs. You will also explore disaster recovery and failover capability, comparing the performance of Hyperscale with traditional architecture.

This book is designed for SQL architects, data engineers, and DBAs who want to optimize their database infrastructure and achieve the most efficient and cost-effective solutions. Whether you are new to Azure SQL Hyperscale or have experience with other cloud databases, this book will provide you with the knowledge and skills you need to succeed in your database projects.

Weight: 920g
Dimension: 254 x 178 (mm)
ISBN-13: 9781484292242
Edition number: 1st ed.