SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability20
SAP Multilevel Client-Server Architecture
This section describes how mySAP architecture relates to SQL Server 2005. It includes an overview of the NetWeaver Application Server, formerly the SAP Web Application Server. This section also describes security, statement execution, database schema, and information for migrating and upgrading to SQL Server 2005.
Note that some of the information in this section is unique to mySAP products and does not necessarily follow the practices used by SQL Server 2005 in other applications.
All SAP products employ a multitiered client-server architecture as shown in the following diagram.
The SAP multitiered client-server architecture is comprised of three levels:
Presentation tier. This tier supports SAP Graphic User Interfaces (GUIs) such as SAP GUI, SAP WebGUI, and other products that connect to the SAP NetWeaver Application Server by using one of the supported interfaces. The Presentation tier also enables applications to access SAP using Web services. Examples might be applications that include smart clients and Microsoft Office applications that integrate SAP data, such as when Microsoft Excel is used with Web services.
Note that the Web services interface will be supported in the NetWeaver 2004S Application Server release.
Application tier. This tier can contain multiple SAP NetWeaver Application Server instances, with each instance pointing to the same database server. Each application server instance is typically run on separate server hardware. However, the Application tier and Database tier can run on the same server hardware on small-scale systems and in some very large hardware configurations.
Database tier. This tier supports the SAP database, including mySAP or R/3 and other SAP applications that are hosted on SQL Server 2005. The Database tier typically runs one database schema for each SAP product by using separate server hardware. The database servers can be connected to a Storage Area Network, NAS, or locally attached storage.
Microsoft Corporation © 2005