Scalability and Very Large Database (VLDB) Resources

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 theSQL 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