stop HANA services

[former_member186273]

Hi Expert

I had HANA database installed on  SLES 11 successfully (finally!!). The machine has 12G memory and 900+G disk space. Well, finally I can bring it up with HANA Weekstore 42. However, HANA eat up all of the memories once all services are running (Well, except the statisticsserver).

I don't know what  the minimal memory hana required? someone please tell me, I googled around but couldn't find the exact number.

Here is my question.

Is it possible to stop one of the services?

nameserver,preprocessor,indexserver,indexserver.c,scriptserver,statisticsserver,xsengine,sapwebdisp

For example, can I stop the xsengine if I don't need it so far?

When I tried to kill xsengine, the deamon brought it up automatically, there must be some configuration to stop it.

Basically what I want is to cut down the useless services and make sure my hana box running fine. Otherwise, outofmemory will throw out.

* 129: transaction rolled back by an internal error: Out of memory $REASON$ SQLSTATE: 40000

Please kindly help.

Thanks

Ethan

[hyungsang_park]

Hi Ethan,

Here is the SAP note about how to remove xsengine and statistics services.

SAP Note No. 1697613- XS Engine Service aus der Topologie entfer

SAP Note No. 1649519- SAP HANA database Revision 18: statisticsserver crashes

Best Regards,

Hyungsang

[former_member186273]

Note 1697613 is German version, do we have E version?