M_SERVICE_MEMORY System View

  • Syed Hussim
  • 01 August 2017
  • 5284
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.

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 - 723 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 - 835 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 - 8064 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 - 6350 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 - 7145 views
  • Adding Auto Numbers To Table Columns

    This article explains how to create an auto generated column using IDENTITY.

    14 March 2018 - 5356 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 - 6927 views

HANA DB

  • JSON_TABLE Function

    SAP HANA has several functions to help query JSON data and in this article, we'll take a look at how to use the JSON_TABLE function to query JSON data stored in a regular column.

    31 March 2023 - 723 views
  • Connect To HANA DB Using Rust

    The hdbconnect package makes it easy to connect to a HANA database using Rust and in this article, we'll take a look at how to establish a connection and perform some queries.

    21 February 2023 - 835 views

Rust

  • Count File Types In Directory

    In this last article on developing a command line program, we'll develop a program that counts the occurrence of different file types in a directory and its sub-directories. The program will accept a directory as an argument and recursively scan all sub-directories. We'll use a HashMap to keep track of the count for each file type.

    29 January 2023 - 906 views
  • Port Scanner

    In the previous article, we developed a simple command line program that counted how many times a word occurred in a text file. The article gave us a brief introduction to the env, collections, and fs modules. In this article, we'll take a look at the TcpStream struct from the net module to develop a simple port scanner.

    05 January 2023 - 2282 views
  • Word Frequency Counter

    The best way to learn any programming language is to develop small meaningful programs that are easy to write and serve a purpose. In this three part article, we'll develop several small command line programs. Each article will focus on a different part of the standard library.

    02 January 2023 - 565 views

Java

  • A Simple HTTP Server - ThreadPool - Part 3

    In part 1, we developed a simple single-threaded HTTP server that processed requests synchronously. In part 2, we modified the server so that each request was handled in a separate thread, which improved concurrency but increased the load on the CPU and memory. In this article, we'll modify the server to use a ThreadPool which will help to improve concurrency while reducing the CPU and memory usage.

    15 January 2023 - 1052 views
  • A Simple HTTP Server - Multi Threading - Part 2

    In part 1, we developed a simple single-threaded HTTP server that returned a static string. While single-threaded servers have their use cases, they lack scalability. The nature of a single-threaded server means it can only process one request at a time. If there's a request that's taking a long time to process, all other requests will be blocked until the slow request has been completed. If we want to handle multiple requests at the same time, we need to use threads.

    22 December 2022 - 1158 views
  • A Simple HTTP Server - Part 1

    NodeJs has built-in http modules that allow developers to build web applications without the need to configure and run a proprietary HTTP server such as Apache or Nginx. Other programming languages provide similar libraries that allow developers to bundle a server with an application. So in this article, we'll take a look at how easy it is to write a simple single-threaded HTTP server in Java. Once we're done, we can run a simple test using Apaches ab tool to determine how many requests per second the server can handle.

    06 December 2022 - 1580 views

SAP Business One

  • Stock Transfer Part 2

    Batch managed items can be transferred between warehouses and bins by including the BatchNumbers property in the StockTransfers API post request. The BatchNumbers property is an array of batch numbers. Listing 1 below shows an example JSON object that contains an item with a single batch. Notice that the quantity specified for the batch number object is equal to the quantity at the item level.

    07 August 2020 - 3696 views
  • Stock Transfer Part 1

    Developing inventory management tools requires a good understanding of SAP Business One API's. Many API's in the Service Layer documentation lack payload samples leaving developers to do their own research. This article aims to help developers understand the payload data that is required to create a stock transfer.

    12 December 2019 - 5910 views

Node.js

  • A JavaScript Implementation Of The Logo Programming Language - Part 2

    In this article we continue developing the Logo Programming language further by writing a simple TokenCollection class to help traverse the array of tokens returned from the lexer we created in part 1. This class will be used in Part 3, when we develop the parser.

    10 June 2020 - 2522 views
  • A JavaScript Implementation Of The Logo Programming Language - Part 1

    The Logo programming language was designed by Wally Feurzeig, Seymour Papert, and Cynthia Solomon in 1967 as an educational tool. The language was used to program a robotic turtle that would draw graphics given a series of instructions. In later years the physical robot was replaced by a virtual on-screen turtle. Over the years, various institutions and organizations have implemented the language with additional features. Notable major implementations are UCBLogo and MSWLogo.

    06 June 2020 - 4712 views
  • Generating Web API Keys

    If you're building a REST API, chances are you're going to need to generate secure random API keys. You may be tempted to use a third-party library but before you do, consider using the crypto package from Node.js. The crypto module can generate random bytes, which can then be used to create your API keys.

    29 May 2020 - 7289 views
  • Port Scanner

    NodeJs has become one of my go to tools for developing small utilities and services extremely quickly. One such tool that I've developed, is a simple port scanner to help determine which ports are being used.

    31 January 2020 - 3193 views
  • Sorting Algorithms

    I don't often start an article asking a question, but I'll make an exception today. Can you take the following array [8,3,1,9,6,5,7,2,4] and sort it in ascending order? Fairly easy right? Many programming languages provide sorting functions that make tasks such as this a one liner.

    29 November 2019 - 2155 views