Summary
In this chapter, you learned about the two main approaches you can use to improve the performance and throughput of your database solution: scaling up and scaling out. Scaling up involves the addition of more or faster hardware resources. Scaling out involves the addition of more SQL Server 2005 instances to distribute the load on your database solution.
Various techniques of scaling up were discussed. You learned how to scale up the main hardware subsystems of your SQL Server 2005 solution.
The chapter concluded with an examination of the various scaling out technologies available with SQL Server 2005. When considering a SQL Server 2005 scale out technology, you learned to consider the potential latency and any other data issue to see if ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
