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.
1651862 – Release planning for Microsoft SQL Server 2012
SQL Server 2012 Technologies for SAP Solutions
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!
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.