Basic HANA tuning parameters?

[Former Member]

I would like to know wether there are basic tuning parameters for SAP HANA? If yes, which are they? Is there a performance document that describes them?

Best,

Martin

[lbreddemann · Accepted solution]

Hi Martin,

there are no general recommendations to change or modify the HANA instance parameters in order to gain better performance.

In fact, if we would have this set of changes that need to be applied, well, we would make them default

With SAP HANA we try to deliver a platform that deals with all sorts of different DB workloads with the default settings.

Thinking about the effort you have with other DBMS to keep them properly running by constantly checking the parameter setup, this is nothing we want to have for SAP HANA.

- Lars

[Former Member · Accepted solution]

Hi Lars,

I get the point, but no different settings in query execution plans, for threading etc..?

This 'one fits all approach' leaves questions.

Best,

Martin

[lbreddemann · Accepted solution]

Hi Martin,

nope - no special settings for different use cases.

SAP HANA does use dynamic resource allocation. All the time. Automatically.

If your system currently has 160 threads available to work on your query and the query allows for such parallelisation SAP HANA will try to use the 160 threads.Two seconds later other queries might be active and use some threads, then the same query will use whatever threads are left available.

Does this leave you with less direct control on the execution of your statements?

Yep, for sure.

Would you (as as human user) be able to foresee the best way to execute a query any given time upfront?

Nope - no way.

Do you end up with much better resource utilization and query execution time by letting SAP HANA do the execution management for you?

You bet

At the end, you may think about your work computer.

Do you need to modify the process heap allowance for your word processor or the number of threads for your email program to have them work correctly?

Or for your web-browser?

Nope. And yet these programs do run very different resource allocation profiles and the underlying operating system takes care of that for you.

It even optimizes the power consumption and the network traffic for you.

That's what a database platform does for you and should do for you.

- Lars

[rama_shankar3]

Martin:

In general, performance in SAP HANA is directly related to the  hardware sizing and the way you model data in SAP HANA using attribute, analytical and calculation views. Following best practice in modelling is  the key to exploit SAP HANA performance.

On the data load performance, please refer to the below blog and let me know if you need additional tips:

http://www.saphana.com/community/blogs/blog/2013/04/07/best-practices-for-sap-hana-data-loads

Hope this helps.

Rama

[vivekbhoj]

Hi Martin,

Check the below webinar on HANA Performance:

http://scn.sap.com/docs/DOC-43713

Get its presentation here:

http://scn.sap.com/docs/DOC-43543

Regards,

Vivek

[Former Member]

There has been some discussion on this..

Please check link below

http://scn.sap.com/thread/3323690