Skip to Content

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

You must be Logged on to comment or reply to a post.
  • 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!


    • 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