O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Scaling Out

Scaling out generally involves the addition of extra SQL Servers to provide increased scalability. When a SQL Server 2005 instance for a particular database solution is at its maximum potential and unable to meet performance demands, you should consider scaling out. SQL Server 2005 allows you to scale out both the database storage solution and the hardware solution. Chapter 19, covered how you can use data partitioning to scale out your database solution. In this chapter, I will examine the following technologies for potentially scaling out your SQL Server solution:

  • SQL Server instances

  • Clustering

  • Database mirroring

  • Log shipping

  • Replication

  • Shared scalable databases

These various SQL Server 2005 technologies have not necessarily been designed ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required