Chapter 6
Scaling out an Azure SQL Database
Learning Objectives
By the end of this lesson, you will be able to:
- Perform vertical and horizontal scaling
- Run cross-database elastic queries
- Create and maintain Azure SQL Database shards
This lesson covers how to vertically and horizontally scale your system to optimize the performance of your application.
Introduction
You can easily scale up or scale down an Azure SQL database, either automatically or manually. There are two types of scaling: vertical and horizontal.
Vertical scaling refers to switching to a higher or lower service tier, or vertically partitioning the data, which is to store different schemas on different databases.
Horizontal scaling refers to dividing data from a single ...
Get Professional Azure SQL Database Administration - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
