SAP Hana - Indexserver service

Sap Hana Architecture

About

The index server holds all the data tables and temporary results, and therefore dominates SAP HANA used memory.

The main SAP HANA database management component is known as the index server, which contains:

  • the actual data stores
  • and the engines for processing the data.

The index server processes incoming SQL or MDX statements in the context of authenticated sessions and transactions.

See SAP Hana - Services (Process)

The Index Server is the core process of Hana.

Any problem (core dump) in any line of code could brought down the entire Hana instance.

Hana Sdi Architecture

Management

Process Id

You can use:

  • the following bash commands to determine the process ID of the indexserver:
# Version 12
ps -C hdbindexserver  -o pid=
# Old version was: ps -ef | grep indexserver
11554

SAP HANA DB Management Client Console (type '\?' to get help for client commands)
Try to open connection to server process 'hdbindexserver' on system 'HXE', instance '00'
SAP HANA DB Management Server Console (type 'help' to get help for server commands)
Executable: hdbindexserver (PID: 11554)

Limits

Check for the configured address space Resource limitations:

# egrep 'Soft|space' /proc/<indexserver_pid>/limits
egrep 'Soft|space' /proc/1154/limits

The correct output without limitation looks similar like the following example:

Limit                     Soft Limit           Hard Limit           Units
Max address space         unlimited            unlimited            bytes





Discover More
Hana Adapters Architecture
HANA - Adapter (Virtual Table)

Every Java developer can now extend Hana by writing new Adapters with a few lines of code. The foundation of this feature is Hana Smart Data Access. Adapter create virtual tables, which are views on...
Sap Hana Architecture
HANA - Database (multiple-container|multitenant )

The database object of HANA. Since SPS 09 (Revision 90),, SAP HANA system can be installed in multiple-container mode, which means it is capable of containing multitenant database containers. A multiple-container...
Sap Hana Studio Hdbconsole
HANA - HdbCons (DB Management Client Console)

The SAP HANA database server management console (hdbcons) is an expert HANA management tool. Command client on the server. Per default hdbcons will connect to the indexserver process where: pid...
Hdb Sda Premise
HANA - SDI - (Architecture|Components)

Data Provisioning Agent When SAP HANA is deployed: on premise, the Data Provisioning Server within SAP HANA connects to the agent using the TCP/IP protocol. (Port 5050) in the cloud or behind a firewall,...
Sap Hana Architecture
HANA - Smart Data Integration (SDI)

The SDI product consists of three main building blocks: The Hana Index Server (core HANA process), the Data Provisioning Server (core HANA process) and the Data Provisioning Agent (Extern process,...
Sap Hana Architecture
Hana - System parameters - (System Property|Configuration File|Parameter)

/usr/sap/ sid inst is the instance number saphelp_hanaplatform/helpdata/en/3f/1a6a7dc31049409e1a9f9108d73d51/content.htmConfiguring SAP HANA System Properties (INI Files) SAP...
Hdb Thread Stat Systemdb
SAP HANA - Statistics service (Alert|ESS)

The SAP HANA statistics server (or: statistics service) is a central tool for monitoring the SAP HANA database. Among others it performs the following tasks: Regular check for critical situations...
Sap Hana Architecture
SAP HANA Database (hdb)

SAP HANA is anin-memory database (db) that can be deployed: on premise (on a machine) or on demand (in the cloud) saphelp_hanaplatform/helpdata/en/0c/9b3b1363634183ab8cd370a66c78df/content.htm?frameset=/en/d3/d1cf20bb5710149b57fd794c827a4e/frameset.htm¤t_toc=/en/d4/3377c2bb57101489ebe2e6a1813cfc/plain.htm&node_id=6&show_children=falseUse...
Sap Hana Architecture
SAP Hana - Data and Log Volume (File)

Each volume contains one file (datavolume_0000.dat) in which data is organized into pages, ranging in size from 4KB to 16MB (page size class). During the installation process, the following default...
Sap Hana Studio Administration Landscape
SAP Hana - Services (Process)

An SAP HANA system consists of multiple services In order to persist data to disk, each SAP HANA service (that persist data ie nameserver, indexserver, xsengine) has its own separate savepoints. ...



Share this page:
Follow us:
Task Runner