SQL Server 7.0 Performance Tuning Guide (white paper)

Article translations Article translations
Article ID: 322883 - View products that this article applies to.
This article was previously published under Q322883
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

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/en-us/library/aa226166.aspx
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

Properties

Article ID: 322883 - Last Review: November 2, 2013 - Revision: 3.0
Applies to
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbinfo kbwhitepaper KB322883

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com