Both HANA Studio and HANA Cockpit provide administrative tools to visualize memory usage by service. If these tools are not available, you can query the M_SERVICE_MEMORY System View using the hdbsql command line program.
SELECT * FROM SYS.M_SERVICE_MEMORY
If your HANA system contains multiple tenant databases, you will need to login to each tenant database and execute the query above. There are two fields from the query result that are of interest (EFFECTIVE_ALLOCATION_LIMIT, TOTAL_MEMORY_USED_SIZE).
The effective allocation limit of a service indicates how much physical memory a service can use given the current memory usage of other services. The total memory used size is the total memory being used by the service. You should ensure that TOTAL_MEMORY_USED_SIZE is below the EFFECTIVE_ALLOCATION_LIMIT. If the total memory used begins to reach the allocation limit, it may lead to out-of-memory failure.
If Table Exists Function
In this article, I explain how to create a function to determine if a table exists in SAP HANA.31 October 2019 - 3326 views
Connect To HANA DB Using NodeJs
This article explains how to connect to a SAP HANA system using the Node HANA client library.28 October 2019 - 3230 views
Connect To HANA DB Using Python
This article explains how to connect to a SAP HANA system using the Python hdbcli package.11 October 2018 - 4447 views
Adding Auto Numbers To Table Columns
This article explains how to create an auto generated column using IDENTITY.14 March 2018 - 1791 views
Connecting To SAP HANA Using PHP ODBC
This article describes how to install and configure PHP odbc to connect to a SAP HANA system on Ubuntu 16.01 December 2017 - 4222 views
Connect To HANA DB Using Java
This article describes how to connect to a HANA DB system using the ngdbc.jar Java driver.03 November 2017 - 2848 views
Loading And Unloading Column Table Into And From Memory
This article explains how to load and unload a column table into and from memory.18 October 2017 - 1824 views