Skip to Content
Author's profile photo Jairo Pedroza
Jairo Pedroza
May 7, 2012 1 minute read

SAP ECC 6.0 running with MS SQL Server 2012

We had privilege to deliver SQL 2012 First Customer Shipment project, using SAP Migration Standard Tools.

In May, 1 we had Production system Go Live and I’d like to share benefits so far.

OS Source: Windows Server 2003

OS Target: Windows Server 2008 R2

DB Source: MS SQL Server 2005

DB Target: MS SQL Server 2012

>>> Saving Storage: Reduction 75% size used (Data compression)

>>> SAP ECC Performance: Response time much better than before.

>>> I/O: Huge I/O reduction improving performance

>>> Backup: Compressed and faster (Backup compression)

>>> Monthly growth in GB was reduced ( Compression )

>>> BI Solution process: Reduce from 7hours to 3min

See few results……… 100% UPTIME !!!

/wp-content/uploads/2012/05/prod5_107593.jpg

Dialog Response Time after 9 months:

Produquimica_RT.jpg

Microsoft Case Study

http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?casestudyid=710000001454

Links for more information about SAP Applications on MS SQL Server 2012 and Case study.

http://www.microsoft.com/casestudies/Microsoft-SQL-Server-2012-Enterprise/Wei-Chuan-Foods-Corporation/Food-Manufacturer-Keeps-Competitive-Edge-and-Improves-Support-for-Growing-Business/710000000330

http://blogs.msdn.com/b/saponsqlserver/archive/2011/11/17/microsoft-s-sap-deployment-and-sql-server-2012.aspx

http://www.microsoft.com/casestudies/Microsoft-SQL-Server-2012-Enterprise/Microsoft-Information-Technology-Group-MSIT/Microsoft-Uses-SQL-Server-2012-5.8-Terabyte-SAP-ERP-Database-to-Run-Its-Global-Business/710000000346

http://blogs.msdn.com/b/saponsqlserver/archive/2012/03/29/sql-2012-is-released-amp-running-live-at-wei-chuan-foods-taiwan.aspx

SAP Notes:

1651862 – Release planning for Microsoft SQL Server 2012

SQL Server 2012 Technologies for SAP Solutions

http://ecohub.sap.com/api/resource/4fabc95ad2a87c2a63d2b792

Jairo Pedroza

ITST Consulting

www.itst.com.br

http://itst.com.br/noticias/sap-netweaver-7-0-ou-maior-com-microsoft-sql-server-2012/

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Valerio Cicchiello
      Valerio Cicchiello

      Hello Jairo,

      to make a reliable test I think you should only upgrade the DB and leave everything else untouched.

      In your scenario, you changed OS and probably HW too, so the performance improvement are not uniquely related to the DB upgrade.

      Could you please give the community more details?

      Thanks for sharing your experience!

      Valerio

      Author's profile photo Jairo Pedroza
      Jairo Pedroza
      Blog Post Author

      Hello Valerio,

      Thanks for your comments.

      For sure, performance improvement are not related only with DB Upgrade and you are right about new hardware.

      It was a project that we implemented: MS SQL Server Best Practices for datafiles and log distribuition, memory configuration, storage configuration taking account IOPS, DB compression, and so on.

      During database export/import, your will reaorganize whole database. All indexes will be recreated. From my point of view, a group of factors contribute for result in Performance reached.

      Regards,

      Jairo Pedroza