cancel
Showing results for 
Search instead for 
Did you mean: 

HANA 2.0 DB - Queries

former_member201054
Contributor
0 Kudos
149

Hi Experts,

Could you please answer the below queries directly instead pointing to SAP notes.

1) How can we see the number of loaded tables and overall % after HANA system restart?

2)What factors can be considered for determining whether a table need an index creation or partitioning from performance perspective?

3)Can workload class override the global allocation limit, statement memory limit and CPU utilization control parameters?

4)How can we control the CPU utilization using workload classes?

5)How many child threads can be possible to a parent thread?. Where to identify and limit it?

6)How can we stop the running delta merges in order to manage the system load and performance ? Is it safe and advisable?.

7) Is it possible to schedule delta merges to a particular time?..

😎 How can we find the tables running delta merges so often?

9) How to find the delta % gap of a table before running delta merge?

10) Can we trigger delta merges whenever needed to all tables?

Thanks in advance

Accepted Solutions (0)

Answers (2)

Answers (2)

mamartins
Active Contributor

SAP have plenty of documentation available to everyone, please use it!

There is the HANA documention here: https://help.sap.com/docs/SAP_HANA_PLATFORM?locale=en-US

arunkumar_bp
Explorer
0 Kudos

Daniel,

you can refer the HANA standard SQL statement collection which will help to clarify most of the queries.

Regards,