M_SERVICE_MEMORY is a System View, that is used to provide detailed information about memory usage for HANA services. The service that consumes the most amount of memory is the indexserver. The indexserver provides numerous functionalities such as processing incoming SQL and MDX statements. It also contains the actual data and data logs. As a result, the memory consumption of this service may increase over time.
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.
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.
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.
HANA DB Articles
-
JSON_TABLE Function
In this article, we'll take a look at how to use the ++JSON_TABLE++ function to represent JSON data stored in a regular column as a relational table.
31 March 2023 - 2697 views -
Connect To HANA DB Using Rust
Learn how to connect and query a HANA database using Rust with the hdbconnect package.
21 February 2023 - 2758 views -
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 - 8833 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 - 7128 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 - 7979 views -
Adding Auto Numbers To Table Columns
This article explains how to create an auto generated column using IDENTITY.
14 March 2018 - 6254 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 - 7641 views