Previous Versions

Scalability and Very Large Database (VLDB) Resources

Find the tools and resources you need to achieve the highest levels of scalability using SQL Server. For more information, read the SQL Server Scalability FAQ

On This Page

	Evaluate
	Plan
	Build
	Operate

SQL Server Scalability Case Studies

With SQL Server 2000, organizations can achieve improved response time, lower transaction costs, reduced administrative costs, and enterprise-class scalability and availability. See how real-world businesses use SQL Server to rapidly adapt to a constantly changing environment.

•	SQL Server Video Case Studies
•	Winter Corporation Spotlight on SQL Server

---

Evaluate

Discover how SQL Server scales to meet the needs of the most demanding large database systems.

•	Scalability Features SQL Server 2005: Decision Support Scalability Improvements Strategies for Scalability with Microsoft SQL Server SQL Server 2000 (64-bit) Product Overview SQL Server 2000 (64-bit) Demo SQL Server 2000: Ease of Use and Scalability for Admins and Users

•	Benchmarks SQL Server Customers Get Worldwide Recognition for Enterprise-Class Scalability SQL Server Achieves World Record An Enterprise Server and Storage Architecture for Scalability, Availability, and Manageability

---

Plan

Planning is essential if you want to create a highly scalable and reliable database system. Use these resources to get prepared and achieve the scalability and reliability that your large database system demands.

•	Large System Considerations Partitioning Very Large Databases Planning for Disaster Recovery

•	Server Consolidation Planning for Consolidation with SQL Server 2000 SQL Server Consolidation on the 64-bit Platform SQL Server Consolidation on the 32-bit Platform Using a Clustered Environment Microsoft SQL Server 2000 Scalability Project—Server Consolidation

---

Build

Take your planning to the next level. See how your database will respond to the demands of your users and applications. These resources and tools will help you determine the real-world requirements for your data and introduce technologies that can help you build scalable and reliable database applications more rapidly and easily.

•	Large Memory Configuration How to Configure Memory for More than 2 Gigabytes (GB) Managing Address Windowing Extensions (AWE) Memory

•	Performance and Stress Testing SQLIO Disk Subsystem Stress Tool How to Use the SQLIOStress Utility to Stress a Disk SubsystemIOMETER: Intel‘s I/O Performance Analysis Tool SQL Profiler Tool

•	Build Large Business Intelligence Solutions SQL Server 2000 Analysis Services Operations Guide SQL Server 2000 Analysis Services Performance Guide

•	Estimate Storage and Server Requirements Microsoft Datasizer Tool System Sizing Tools on the HP Web Site System Sizing Tools for SQL Server on the Unisys Website

•	Implementing a Storage Area Network (SAN) SQL Server 2000 I/O Configuration in a SAN/NAS Environment About EMC and Microsoft Product Integration HP SAN in SQL Server 2000 Environments Microsoft Windows Clustering: Storage Area Networks Running SQL Server 2000 on Dell SAN

•	Support for Network Area Storage (NAS) Support for Network Database Files

---

Operate

Data is only useful if you can access it, which makes good operation procedures critical. Learn how SQL Server provides rich capabilities that you can use to operate large, high performance databases. These resources will help you collect the data you want while providing the high availability and reliability that your users expect.

•	Data Loading Optimizing Bulk Copy Performance Enhancing Performance of DTS Packages

•	Backup and Restore Exploring Backup and Restore Performance Using a Tape Library

•	Performance Monitoring and Tuning How to Troubleshoot Application Performance with SQL Server How to Monitor SQL Server 2000 Blocking

Top of page

Manage Your Profile © 2006 Microsoft Corporation. All rights reserved.  Terms of Use | Trademarks | Privacy Statement