Advertisement

Scaling Workloads

  • Peter A Carter

Abstract

SQL Server provides multiple technologies that allow DBAs to horizontally scale their workloads between multiple databases to avoid lock contention or to scale them horizontally between servers to spread resource utilization. These technologies include database snapshots, replication, and AlwaysOn Availability Groups. This chapter discusses the considerations for these technologies and demonstrates how to implement them.

Keywords

Replication Agent Source Database Distribution Agent Snapshot Isolation Isolation Level 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material

978-1-4842-0710-9_16_MOESM1_ESM.zip (10 kb)
978-1-4842-0711-6_CH16.zip (zip 11 kb)

Copyright information

© Peter A Carter 2015

Authors and Affiliations

  • Peter A Carter
    • 1
  1. 1.BotleyUK

Personalised recommendations