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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Peter A. Carter
About this chapter
Cite this chapter
Carter, P.A. (2019). Scaling Workloads. In: Pro SQL Server 2019 Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5089-1_16
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5089-1_16
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5088-4
Online ISBN: 978-1-4842-5089-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books