Skip to Content
Author's profile photo Jairo Pedroza

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 !!!


Dialog Response Time after 9 months:


Microsoft Case Study

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

SAP Notes:

1651862 – Release planning for Microsoft SQL Server 2012

SQL Server 2012 Technologies for SAP Solutions

Jairo Pedroza

ITST Consulting

Assigned Tags

      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!


      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.


      Jairo Pedroza