SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability3
SAP Solutions and SQL Server
SAP and Microsoft have been working together to develop tight integration between SAP solutions and SQL Server:
SAP R/3 for Microsoft Windows NT® version 3.51 was released in 1994. By mid-1995, SAP began using R/3 with SQL Server™ version 6.0 in customer implementations.
Between 1996 and 1998, SAP and Microsoft developed SQL Server™ version 7.0 by building on their direct experience with customers. In particular, the SQL Server development team removed limitations on the use of SQL Server with SAP systems to improve scalability and performance. SQL Server 7.0 was released at the end of 1998.
The release of Microsoft SQL Server™ 2000 dramatically improved the performance and administration of SAP products. Using standard benchmarks, SQL Server 2000 performed best on an Intel® hardware platform running the Microsoft Windows Server™ operating system. Customers migrating to SQL Server 2000 were able to increase system performance by extending memory addressability using Microsoft Windows Server™ 2000 and Windows Server™ 2003.
SAP with SQL Server 2005
Today, Microsoft SQL Server 2005 Enterprise Edition is the foundation of a tightly integrated data platform that can be used to share and apply company information. SQL Server 2005 Enterprise Edition was tuned jointly with Microsoft and SAP engineers to ensure maximum performance, reliability, and enhanced interoperability.
The advantages of using SAP with SQL Server 2005 include:
Improves performance. Enhancements in SQL Server 2005 enable tune-up and autoadministration features to work for all SAP application deployments.
Supports very large databases. mySAP and R/3 installations running on SQL Server 2005 can accommodate larger and more complex databases. Multiterabyte databases and 45,000 tables in a single mySAP database are increasingly more common.
Offers advanced capabilities as standard features. Customers can take advantage of these capabilities without the need for additional licenses, limitations, special hardware, or special database versions.
Contains comprehensive data management features. Data management features include advanced data mining; integration services; extraction, transformation, and loading (ETL); BI; high availability; manageability; and security.
Runs on standard commodity servers and storage. SAP customers have two options for licensing SQL Server 2005. When SQL Server 2005 is licensed through Microsoft and is used for more than one application, the database is licensed per processor, not per core, as is common with some competitors. This reduces the cost by a factor of three or greater. When SQL Server 2005 is licensed through SAP and is used for one application only, even greater savings can be realized.
Microsoft Corporation © 2005