This Blog will provide information about running SAP applications on SQL Server and Windows. The Blog is written by folks of Microsoft who are working with SAP and SQL Server for more than a decade.
Microsoft’s internal ERP solution is the SAP Suite of products including SAP ECC 6.0, SAP BW and SAP SCM. Microsoft tests new SQL Server releases and Service Packs on not only test SAP systems but also the core ECC Production system that runs Microsoft worldwide. The ECC 6.0 single instance, single client system is accessed by 95,000 users worldwide and transacts the majority of the $65B USD in revenue each year. SQL Server 7, SQL 2000, 2005, 2008 R2 were all tested on the core ECC Production system before these products were released. Microsoft will follow the same process with SQL 2012 so that customers can have the confidence that no version of SQL Server is ever released without running Microsoft’s own production SAP system for several months. We want to catch up with this article and give a status update on our internal deployments.
Since January 2011 we tested SQL Server 2012 builds in a sandbox representing around half of the capacity of our productive SAP ERP systems. Besides testing the functionality used by SAP, one of the major tests areas were around our new HA/DR functionality offered in SQL Server. We combined this set of functionality under the name AlwaysOn in SQL Server 2012 (http://msdn.microsoft.com/en-us/sqlserver/gg490638 ). All the old methods like Windows Clustering, Database Mirroring and Log-shipping still ship in SQL Server 2012. The new AlwaysOn functionality which allows more flexibility and functionality like multiple secondaries or online reading from secondaries, is offered in parallel to the ‘old’ functionality. At the beginning of the tests in the sandbox we started with Database Mirroring as HA method. Once we proofed that Database Mirroring was working flawlessly we moved the High Availability configuration to AlwaysOn with 2 replicas (one principal and one secondary) basically replacing Database Mirroring. Since July we had a 3rd replica ( one additional secondary) added into the HA/DR configuration to test the replacement of Log-shipping to our Disaster Recovery Datacenter. In opposite to the combination of Database Mirroring plus Log-shipping as we used it so far, we now had all three servers using the same AlwaysOn functionality to replicate the changes. We had one place to configure the HA/DR configuration and one place to monitor whether everything would run fine. All tests around our new HA/DR technology went pretty well. Feedback out of these tests to SQL Server Development was used to improve and fine tune AlwaysOn technology. From that point of view, the early testing we did together with our SAP Basis team can be considered as very successful by Microsoft IT as well as SQL Server development. Besides AlwaysOn we tested a new trace flag which I documented earlier here . This new functionality also proved to be a full success, eliminating some well-known issues we sometimes encountered with query plan generation.
We moved our sandbox system to a late CTP3 Refresh build in July and continued to run testing on it checking different features and functionality.
In mid of August we focused our attention our official SAP ERP test instance which is located in our DR site and is used for Business Regression, workload and scalability testing. As such this system is an exact copy of our productive SAP ERP system. We moved that SQL Server 2008 R2 instance onto SQL Server 2012 CTP3 Refresh with and in-place upgrade. We replaced Database Mirroring in this test system as well with AlwaysOn in a 2-replica configuration. Scalability tests with AlwaysOn using our Business Regression Test Suite plus index rebuilds executed in parallel did show that the replication of transaction log data between primary and secondary is scaling way better than DBM ever did. Scenarios of high volume workload could cause effects like described here. Whereas the new designed data transaction log transfer did not show any problems. Experience made in our SAP Test System were extremely positive and paved the way to move SQL Server 2012 into our productive system as planed mid of November.
As a last instance we moved our productive SAP ERP instance to refreshed SQL Server 2012 CTP3 Refresh build on 11/11/2011. It was during our usual quarterly maintenance which we usually use to get new SAP kernels and SAP Support Packages applied to our SAP ERP system when we performed in-place upgrades of our SQL Server 2008 R2 instances to SQL Server 2012. The sequence of the steps taken looked like:
After the SAP system was up and running again:
After all support packages and transports were applied to the SAP ERP system, we performed the following steps
So far the system behaves perfectly and shows great performance. Not a single issue came up in the week that we are productive. So far so good.
Thanks Juergen to share all these information !
Yes, it gives confidence to customers..
Any insides on when SQL 2012 will be fully supported for SAP products? We are in the planning of moving to Windows 2008/SQL 2008 but it might make sense to wait a little and go all the way to SQL 2012.
Any information will be greatly appreciate it.
I can't release exact dates of when SAP will support SQL Server 2012 officially. Not that we don't have a schedule. Schedule is there and execution on it already started. SAP will start evaluating SQL Server 2012 starting in April. Therefore I assume that we get GA from SAP in summer time frame. What makes the process taking a bit longer is that we created a complete new master installation DVD for SAP which should cover most of the releases from 7.00 on. However the advantage is that one could install a 7.00 based ERP against SQL Server 2012 directly. Please check OSS note #1651862 which lines out the Release strategy around SQL Server 2012 and also describes an exception process which would allow customers going productive before SAP announces general availability
Thanks for this great post.
I have a question regarding the Available DR and Clustering Options for SAP with WSFC.
I have a customer for which we implemented an SAP HA using WSFC for both SAP ERP and MS SQL Server. We are running on Windows Server 2008 R2 and SQL Server 2008 R2.
Now the customer is planning for a DR Site that has to replicate the Running Primary Site. The Primary Site is a 2-node cluster where both SAP EPR and SQL Server are clustered with WSFC.
Is it supported to have a 2-node DR Site for such Primary Site Configuration ? and what are the available options/procedures to realize a DR site for the current customer running site.