November 28, 2018

SAP HANA Administration

SAP HANA is an in-memory database for performing real-time data analysis, and development of applications on the top of real-time data. HANA administration deals with managing SAP HANA system in a single and distributed system environment. Each HANA system can contain multi node architecture with each node containing multiple processors for fast speed data analysis and real-time data provisioning. You can use Smart data access to get the data from non-SAP systems without importing the data to HANA database, and virtual tables can be used to perform read/write data operations

SAP HANA Administration includes the following activities −

  • SAP HANA multiple host system management
  • SAP HANA Administration Tools
  • SAP HANA System Management and Availability
  • SAP HANA Lifecycle Management
  • SAP HANA Security and User Management
  • SAP HANA Backup and Recovery Management
  • SAP HANA Data Provisioning and Integration with non-SAP systems

Each SAP system contains multiple servers and it can be checked in HANA Studio under Administration tab. SAP HANA Studio contains Administration Perspective (default) to manage all admin tasks in HANA systems.

To check the landscape of HANA system, navigate to Landscape tab in HANA studio. Services shows all the services running on HANA system.

The following screenshot shows SAP HANA system and all the key services running under system Landscape for the same system.

You can see the service name corresponding to each server in HANA system landscape.

Services

From the dropdown list, you can select all the host names and services that you want to see and the status of each system.

Various details available for each service includes: Start time, CPU and Memory details, Used Memory, Peak Used Memory, Effective Allocation Unit, Physical Memory on host, and SQL Port.

Landscape

When you click the Hosts tab, you can see the host names in the System Landscape and the role of HANA system defined under Name server.

You can also check the status of the systems, failover status, Index server role, and Failover group.

Hosts Tab