HANA News Blog

Intel COD / SNC NUMA feature

Matthias Sander + Jens Gleichmann • 28. September 2023

Possible performance degradation or inconsistencies

Sub-NUMA Clustering by Frank Denneman

--Scroll down for English version


Es gibt ein Intel Feature mit dem Namen SNC bzw. COD. Dabei steht SNC nicht für Secure Network Connection, sondern für Sub-NUMA Clustering. COD steht hier nicht für ein Videospiel, sondern für Cluster-On-Die.


Diese Features werden bei neuerer Hardware eingesetzt und wird ca. seit zwei Jahren teilweise standardmäßig aktiviert (beispielsweise bei HPE).

Die Features dürfen unter keinen Umständen mit HANA verwendet werden. Neben Performanceproblemen können ebenso Inkonsistenzen auftreten!


Es wird ein phys. NUMA Node in zwei NUMA Nodes aufgeteilt. Bei einem unserer HANA Health Checks wird neben der Datenbank auch von Storage über Hypervisor und OS einiges überprüft. Bei einem Kunden, für den wir einen solchen Health Check durchgeführt haben, ist uns aufgefallen, dass der ESXi bei einem phys. 2 Sockelserver plötzlich 4 NUMA Nodes anzeigt.


Auf ESX Ebene kann dies mit dem folgenden Kommando überprüft werden:

echo "CPU Packages";vsish -e dir /hardware/cpu/packageList;echo "NUMA nodes"; vsish -e dir /hardware/cpuTopology/numa/nodes

Das Feature kann im BIOS deaktiviert werden (Beispiel HPE).

####################################################English#########################################################


There is an Intel feature called SNC or COD. SNC does not stand for Secure Network Connection, but for Sub-NUMA Clustering. COD does not stand for a video game, but for Cluster-On-Die.


These features are used in newer hardware and have been partially activated by default for around two years (for example at HPE).

The features may not be used with HANA under any circumstances. In addition to performance problems, inconsistencies can also occur!


A physical NUMA node is divided into two NUMA nodes. During one of our HANA health checks, not only the database but also the storage, hypervisor and OS are checked. We noticed at one customer that the ESXi suddenly shows 4 NUMA nodes on a physical 2 socket server.


At ESX level, this can be checked with the following command:

echo "CPU Packages";vsish -e dir /hardware/cpu/packageList;echo "NUMA nodes"; vsish -e dir /hardware/cpuTopology/numa/nodes

The feature can be deactivated in the BIOS (example HPE).

Source

2470289 - FAQ: SAP HANA Non-Uniform Memory Access (NUMA):

Is it possible to use sub-NUMA clustering for SAP HANA?

On BIOS/UEFI level it is possible to define more than one NUMA node per CPU socket (Intel Cluster-On-Die (COD) / sub-NUMA clustering technology). This scenario isn’t supported and can result in SAP HANA persistence corruptions (SAP Note 2116157).


2116157 - FAQ: SAP HANA Consistency Checks and Corruptions

"Unsupported activation of Intel Cluster-On-Die (COD) / sub-NUMA clustering technology"


Details:

Sub-NUMA Clustering by Frank Denneman


support Intel COD/SNC

SAP HANA News by XLC

von Jens Gleichmann 14. April 2026
KVM as alternative with low TCO
inverted individual index is a special type of SAP HANA index wich can save memory
von Jens Gleichmann 6. April 2026
An inverted individual index is a special type of SAP HANA index which can only cover unique indexes. This includes all primary key structures. Unlike traditional column store indexes on more than one column (inverted value, inverted hash) an inverted individual index (Inv Idv Idx) doesn't need a dedicated concat.
Total NSE savings
von Jens Gleichmann 5. April 2026
This blog presents the results of a customer case which can be used as a reference for other implementations
SAP HANA performance issues with THP on multi-NUMA node systems
von Jens Gleichmann 30. März 2026
SAP HANA systems may experience high swap usage, hangs, or performance issues when THP (Transparent Huge Pages) is enabled with "madvise". This occurs on multi-NUMA node systems where one or more NUMA nodes are close to full memory usage while others have plenty of free memory, and counters for THP allocations, direct
Transparent Huge Pages (THP) with madvise can trigger high swap usage and performance issues
von Matthias Sander 26. Januar 2026
Transparent Huge Pages (THP) with madvise can trigger high swap usage, performance issues, or even system hangs on multi-NUMA systems.
HANA performance degradation after upgrade to SPS07+SPS08
von Jens Gleichmann 9. Januar 2026
With SPS06 and even stronger in SPS07 the HEX engine was pushed to be used more often. This results on the one hand side in easy scenario to perfect results with lower memory and CPU consumption ending up in faster response times. But in scenarios with FAE (for all entries) together with FDA (fast data access), it can result in bad performance. After some customers upgraded their first systems to SPS07 I recommended to wait for Rev. 73/74. But some started early with Rev. 71/72 and we had to troubleshoot many statement. If you have similar performance issues after the upgrade to SPS07 feel free to contact us! Our current recommendation is to use Rev. 74 with some workarounds. The performance degradation is extreme in systems like EWM and BW with high analytical workload.
SAP HANA NSE - a technical deepdive with Q&A
von Jens Gleichmann 24. November 2025
SAP NSE was introduced with HANA 2.0 SPS04 and based on a similar approach like data aging. Data aging based on a application level approach which has a side effect if you are using a lot of Z-coding. You have to use special BADI's to access the correct data. This means you have to adapt your coding if you are using it for Z-tables or using not SAP standard functions for accessing the data in your Z-coding. In this blog we will talk about the technical aspects in more detail.
Partitioning process
von Jens Gleichmann 24. November 2025
SAP HANA scaling and tuning with proper partitioning designs
R+R: intersection and missing services
von Jens Gleichmann 25. September 2025
In transformation projects like SAP RISE / SAP Cloud ERP, the Roles & Responsibilities (R+R) list often serves as the backbone for collaboration between customer, partner, and SAP. Yet too often, this list is treated as a static document rather than a living framework. Sometimes nobody knows exactly what was defined by
Why Databases Need Optimizer Statistics – With a Focus on SAP HANA
von Jens Gleichmann 28. Mai 2025
In the world of modern database management systems, query performance is not just a matter of hardware—it’s about smart execution plans. At the core of generating these plans lies a critical component: optimizer statistics. This article explores why databases need optimizer statistics, with particular emphasis on SAP HANA, while drawing parallels with Oracle, Microsoft SQL Server (MSSQL), and IBM DB2.
more