Article ID: 322873
Article Last Modified on 5/29/2002
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q322873
SUMMARY
SAP R/3 database administrators must understand and use certain tuning methods for SQL Server 7.0 to provide maximum performance under the heavy database workloads found in the SAP R/3 environment.
A downloadable guide that describes the configuration options you must consider when working with Microsoft Windows NT Server and SQL Server is available.
The guide may also help administrators of large databases who support many users and large workloads.
The guide pays particular attention to the optimal design of SQL Server indexes in large SAP R/3 installations. To download the guide, please visit the following Microsoft Web site:
SAP R/3 Performance Tuning Guide for Microsoft SQL Server 7.0
Included in this document:
- Windows NT Configurations
- SQL Server Configurations
- Index Design and Maintenance
- File and Filegroup Design
Additional query words: performance whitepaper
Keywords: kbinfo kbwhitepaper KB322873