Functions of Index server in SAP HANA system

Index Server is heart of SAP HANA system and is responsible for processing all SQL statements sent to HANA database. This server contains SQL/MDX Processing engine that is responsible to process and analyze data in HANA db.

Index Server also contains Persistence layer for scalability and restoration of the system. In case of system failure, power failure or database corruption, Persistence layer is responsible for the restoration of HANA system to last save point.

When you are running complex and large calculations, and there is a system failure Persistence layer is used to ensure that transactions are either fully executed or complete undone using Session/Transaction Manager.

Session and Transaction Manager is responsible to keep track of statements that are executed in HANA system.

Anil SAP Gupta

Published on 21-Feb-2018 18:05:51

• Related Questions & Answers
• Index server in SAP HANA system
• Use of SQL/MDX processor in SAP HANA Index server
• TCP/IP port in SAP HANA to access Index server
• Architecture of SAP HANA system
• Checking performance of SAP HANA system
• Checking version of SAP HANA system
• Lock down of SAP HANA system
• SAP HANA database functions in HANA Cockpit
• System measurement of SAP HANA system in XML file
• Searching a SAP HANA system in HANA Studio System view
• Getting statistics details of SAP HANA system
• Defining Auditing policy of SAP HANA system
• Migrating to SAP HANA system
• Different Aggregation functions in SAP HANA
• Use of Restricted user in SAP HANA system