.NET Architecture & System Design Interview Question #52

How can a relational database be scaled vertically?

Database Scaling, Partitioning, NoSQL & Data Consistency Mid-Level Intermediate

Quick Interview Answer

Vertical database scaling increases the capacity of one database server by adding CPU, memory, faster storage, or higher network capacity.

Detailed Explanation

Vertical database scaling increases the capacity of one database server by adding CPU, memory, faster storage, or higher network capacity.

It is operationally simple and often the first scaling step, but a single machine has practical and financial limits. Vertical scaling also does not by itself remove a single point of failure, so high-availability requirements must be addressed separately.

Code Example

Database Server
  8 CPU / 32 GB RAM
          |
          v
 32 CPU / 128 GB RAM