Skip to Content
avatar image
Former Member

After migrating to HANA, it is slower than before

We recently migrated from Oracle database to HANA in our DEV system.
With migration, we were expecting super fast response time, but it has been that way. In that, HANA now runs slower than Oracle. If everything is stored in RAM, it should be in secs, correct ? but not that way. Can you help us what we can do to make it faster ?

Here was our current SAP system status before we migrated.

EHP7 FOR SAP ERP 6.0, SP Stack = 12 (07/2016)

Thanks,

Niranjan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 28, 2017 at 05:01 AM

    Just using SAP HANA does not mean, that out of the box all things run faster than before, especially custom coding which does not consider some golden rules.

    As SAP standard Business Suite coding (and later S/4 coding) is (or should) be already optimized you have to analyze and improve your custom coding (this is normally a standard step before migrating to SAP HANA).

    Did you do some analysis using e.g.

    • the SQL Monitor
    • running Code Inspector Check variants PERFORMANCE_DB, FUNCTIONAL_DB, FUNCTION_DB_ADDITION
    • comparing the results using the Performance Tuning Worklist.

    If not, you should do this to get some hints regarding performance improvements and also hints for potentional functional issues. For instance the PERFORMANCE_DB check will identify coding in which many single select DB accesses are done or DB accesses are done with a field list containing fields not really required in the coding.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

    • It seems that your didn't do you homework before moving to HANA, when you say that it makes no sense.

      Said in your example with the new computer with more RAM: If your software does not use the new capabilities respectively it is not optimized, it will not run faster.

      Saying that you get a piece of crap, w/o doing your homework before (even making familiar with the facts) and not willing to invest any time in analysis, makes your question in this forum a little bit needless from my point of view.

      Regards,
      Florian