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


The information in this article applies to:

  • Microsoft SQL Server 7.0
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
Modification Type:MajorLast Reviewed:7/29/2005
Keywords:kbinfo kbwhitepaper KB322883
©2004 Microsoft Corporation. All rights reserved.