INF: SAP R/3 Performance Tuning Guide for Microsoft SQL Server 7.0 (White Paper) (322873)



The information in this article applies to:

  • Microsoft SQL Server 7.0

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

Modification Type:MajorLast Reviewed:5/29/2002
Keywords:kbinfo kbwhitepaper KB322873