Microsoft KB Archive/322883

= SQL Server 7.0 Performance Tuning Guide (white paper) =

Article ID: 322883

Article Last Modified on 7/29/2005

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q322883



SUMMARY
The performance tuning guide that this article references provides principles and techniques to help database administrators configure SQL Server 7.0 for maximum performance and to help them determine the cause of poor performance in a SQL Server environment.

This guide also describes how best to use SQL Server indexes and SQL Server tools in analyzing the I/O performance efficiency of SQL Server queries. To view this guide, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/msdn_sql7perftune.asp

Included in this document:
 * Principles for Performance Tuning SQL Server
 * Review the Max Async IO Option During Configuration
 * Components That Consume CPU and Disk I/O Resources
 * Disk I/O Performance
 * SQL Server Indexes
 * SQL Server Performance Tuning Tools
 * Other Performance Topics

Additional query words: performance guide whitepaper

Keywords: kbinfo kbwhitepaper KB322883

-

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

© Microsoft Corporation. All rights reserved.