Chapter 3

SQL Server Scalability and Availability

Solutions in this chapter:

 Scaling Up vs. Scaling Out

 SQL Server Fail-Over Clustering

 Distributed Partitioned Views

 Log Shipping

 Indexed Views

Introduction

Every technology professional has faced issues concerning the availability and scalability of his or her hardware and software solutions. Continued commitment to making SQL Server a player in all markets, from handheld and portable applications to enterprise-scale database solutions, is evident in SQL Server 2000. This latest release of SQL Server provides support for up to 64GB of RAM and 32 processors, with Enterprise Edition running on Windows 2000 Datacenter Server. At the other end of the spectrum, SQL Server now boasts support for database ...

Get Designing SQL Server 2000 Databases 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.