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.
Database Snapshots
A
database snapshot
is a point-in-time view of a database that never changes after it is generated. It works using copy-on-write technology; ...
