HANA Patitioned table - NUMA location

[former_member201054]

Hi Experts,

There is a partitioned table in HANA 2.0 SPS5.

Partition number - 6

* How to identify the Numa location of each partition.?

* How to define the numa location for a table equally while partitioning itself?. so that it will spread across.

Please answer with more details.

Thanks in advance

[Cocquerel · Accepted solution]

1 - You can find assigned NUMA node in M_CS_ALL_COLUMNS.NUMA_NODE_INDEX

2 - See question "Which indications exist for SAP HANA NUMA issues" of note 2470289 - FAQ: SAP HANA Non-Uniform Memory Access (NUMA)