After migrating to HANA, it is slower than before

[niranjan_yerraguntla]

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

[pfefferf]

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

[niranjan_yerraguntla]

Thanks Florian for the reply, but that does not make much sense. We are moving to a better database(HANA), according to SAP, and so without us changing anything, things should be faster, not the other way round. It is like getting a new computer with better RAM and everything will be fast.

Also, do you mean to say that SAP's standard transactions should at least run faster ? I have not seen that either.

We have not looked at SQL Monitor or Code inspector check yet. We have hundreds of Z programs, so it is not an easy task to look at each of them. We are spending hundreds of thousands of dollars for HANA, but looks like getting a piece of crap. Not happy.

Thanks,

Niranjan

[pfefferf]

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