Microsoft KB Archive/322708

= INF: Microsoft SQL Server 2000 Scalability Project - Basic Capacity Scalability (White Paper) =

PSS ID Number: 322708

Article Last Modified on 10/3/2003

-

The information in this article applies to:


 * Microsoft SQL Server 2000 (all editions)

-



This article was previously published under Q322708



SUMMARY
Microsoft SQL Server 2000 running on Microsoft Windows 2000 servers handles the largest mission-critical applications. This white paper is a joint effort by Microsoft and Dell to demonstrate the scalability of SQL Server 2000 and Dell hardware. To view this white paper, visit the following Microsoft Web site:

Microsoft SQL Server 2000 Scalability Project - Basic Capacity Scalability

SQL Server 2000 running on a Dell enterprise eight-way server can support multiple-terabyte databases and handle heavy workload and administrative tasks. SQL Server 2000 maximizes your return on investment in symmetric multiprocessing (SMP) systems, allowing users to add processors, memory, and disks to build large, centrally-managed enterprise servers. The tests that are described in this paper demonstrate the performance and scalability of SQL Server 2000 on very large databases (VLDB) without special tuning or unrealistic benchmark hardware configurations.

Included in this document:


 * Computer Configuration
 * One-Terabyte OLTP Database
 * OLTP Workload
 * Index Reorganization
 * Two-Terabyte and Four-Terabyte Decision Support Systems
 * CREATE DATABASE Statement
 * Bulk Data Loading
 * Index Creation
 * DSS Workload
 * Database Verification

Additional query words: scalabiltiy whitepaper

Keywords: kbinfo kbwhitepaper KB322708

Technology: kbAudDeveloper kbSQLServ2000 kbSQLServ2000Search kbSQLServSearch

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.