Microsoft KB Archive/322866

= INF: RDBMS performance tuning guide for data warehousing (white paper) =

Article ID: 322866

Article Last Modified on 2/11/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q322866



SUMMARY
The performance tuning guide that this article references is designed to help database administrators and developers configure SQL Server 2000 for maximum performance and to help determine causes of poor performance of relational databases, including those that are used in data warehousing. It also provides guidelines and best practices for loading, indexing, and writing queries to access data stored in SQL Server. Various SQL Server tools that can be used to analyze performance characteristics are also discussed.

To view this guide, visit the following Microsoft Web site:

RDBMS Performance Tuning Guide for Data Warehousing

Included in this document:
 * Basic Principles of Performance Tuning
 * Optimizing Disk I/O Performance
 * Partitioning for Performance
 * Finding More Information

Note This chapter was taken in its entirety from the SQL Server 2000 Resource Kit.

Keywords: kbinfo kbwhitepaper KB322866

-

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

© Microsoft Corporation. All rights reserved.