SAP HANA Tips

SAP HANA for beginners
Share on Facebook26Share on LinkedIn2Tweet about this on TwitterShare on Google+0
Please Share!!

In our other post ‘ SAP ABAP Tips‘, we shared some uncommon but very useful tips on ABAP. In this post, I would like to share similar useful tips in regards to SAP HANA.

i) Parameter to limit the CPU usage for a thread in SAP HANA

There is a parameter that can be used to limit the amount of CPU, a thread can take in SAP HANA.

ii) How to find the size of the HANA DB?
We have two aspects here:
a. Column store
b. Row store

a. To find column store utilization:

b. To find row store utilization:

iii) Migrating tables to specified nodes in SAP HANA multi-node system

If you want to migrate a particular table from one node of HANA to another for performance or space issue:

a. To view current location of table

Open SQL editor on HANA studio and run the sql query:

b. To view current location decide the node where you want to move it and run the below query on SQL editor of HANA studio:

Also Read: ‘Smart Data Integrator & Data Load In SAP HANA’

iv) Delivery Classes for tables (Not specific to HANA)

While doing some migrations (BW on HANA ) I felt that we as technical consultant need to have a better understanding of delivery classes. I felt that we need to recap the concept. I am intending to have a small listing of the same. For each database table, a delivery class has to be specified. The delivery class determines the handling of the entries for a specific table during
Transports
Client Copies
– Installation & Upgrades

SE11 Delivery Classes for tables:

Delivery Class in SAP TABLE2 Delivery Classes

Delivery Classes for tables:

SE11

Examples:

CCommon Address Data (Country: T005)
EMessages (T100)
GCommunication: country dialling code (T005K)
LLock Arguments (E070USE)
SLanguage Key (T002)
APersonal Address Data, Username (USR01)
WTransport (E070), Tables (DD02L)

Delivery Classes – Client Copy & Client Transport:

Is Delivery Class copied?

Delivery Classes – Transport SAP -> Customer

Delivery Class

Delivery Classes – Transport Customer -> Customer

Client dependent tables

For more details, please refer SAP Note: 2857

If you want to get such practical tweaks and tricks straight to your inbox, please SUBSCRIBE. We respect your privacy and take protecting it seriously.

If you liked this post, please hit the Share buttons. Please like us at facebook and encourage us.

Thank you very much for your time!!

Series on SAP HANA

1. SAP HANA from Space Level

2. SAP HANA at Ground Zero

3. View the HANA Views from different angles

4. ‘ABAP for SAP HANA’ Points to remember

5. SAP HANA ; S/4 HANA and S/4 HANA Finance in Nutshell

6. Smart Data Integrator & Data Load In SAP HANA

to be updated..

 

Image source: rahulurs.com(modified)

Share on Facebook26Share on LinkedIn2Tweet about this on TwitterShare on Google+0
Please Share!!

About the Author

Vinay Singh
Vinay Singh
Qualification: BE from Bharati Vidyapeeth, India. MBA from Mannheim Business School, Germany. SAP BI/HANA Experience since 2006. Author of books : ‘Real Time Analytics with SAP HANA‘ & ‘Creating and Using Advanced DSOs in SAP BW on SAP HANA‘. Find more about him on LinkedIn.

Be the first to comment on "SAP HANA Tips"

Please help us improve. Please Shout Often & Loud!!