SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability1
Companies face numerous challenges when managing and integrating information across enterprise business processes. Customers need faster analysis and deeper business insight to improve their decision making and to respond to changing business needs. Companies frequently choose an Enterprise Resource Planning (ERP) solution to fulfill these business requirements. The leading ERP applications with the greatest market share are the mySAP™ ERP and SAP® R/3® industry solutions from SAP AG.
mySAP ERP is comprised of a comprehensive range of products that empower the enterprise with a flexible, end-to-end solution. mySAP solutions can increase business productivity, enhance operational efficiency, and reduce total cost of ownership (TCO). mySAP solutions also offer the scalability needed to manage ever-increasing workloads. mySAP solutions enable companies to pinpoint inefficiencies in current business operations and to provide the resources needed to extend best practices to the entire value chain.
A critical challenge in implementing a mySAP solution is in the selection of a data platform that can deliver the advanced features and capabilities needed to support the most demanding workloads. Companies can choose Microsoft® SQL Server™ as the best solution for mySAP. Microsoft SQL Server 2005 is the database of choice for deploying reliable, highly available, high-performance, scalable, and more secure mySAP installations.
SQL Server 2005 is an integrated data management and analysis solution. SQL Server 2005 enables SAP customers of any size to share data across multiple platforms, applications, and devices, while making it easier to connect to internal and external systems. SQL Server 2005 high-availability features can minimize downtime in SAP implementations. SQL Server 2005 maximizes productivity by making it easier to create robust database extensions at a lower cost.
mySAP solutions running on SQL Server 2005 realize native performance improvements. SQL Server 2005 contains built-in tools that simplify installation and make it easy to deploy and manage SAP implementations. In addition, the SQL Server 2005 engine dynamically tunes database parameters automatically to respond to changing usage characteristics.
This white paper describes best practices that customers, system integrators, and partners can use to design, deploy, and operate high-availability SAP implementations by using SQL Server 2005. This paper is provided to ensure that the common aspects of SAP with SQL Server 2005 implementations reflect the specific characteristics of SAP business applications.
The paper describes typical architectures, installation and configuration, and performance monitoring and tuning, including how to resolve common problems. The paper also describes special considerations for SAP® Business Information Warehouse (SAP BW) and for 64-bit computing configurations.
The paper assumes that the reader has at least a general understanding of mySAP ERP solutions and Microsoft SQL Server database concepts and features. The SAP with SQL Server 2005 best practices that are described in this white paper were developed from the combined experiences of thousands of SAP customers worldwide.
Microsoft Corporation © 2005