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

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: 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.