- SAP HANA Admin Tutorial
- SAP HANA Admin - Home
- SAP HANA Admin - Overview
- Architecture Overview
- Multitenant Database
- Multiple Host Systems
- SAP HANA Admin - System Mngmt
- Multitenant DB Container Mgmt
- Starting a HANA System
- Stopping a HANA System
- License Keys
- Monitoring the HANA System
- SAP HANA Admin - Table Mngmt
- SAP HANA Admin - Table Partition
- SAP HANA Admin - Table Replication
- Data Compression
- Solman Integration
- SAP HANA Admin - Lifecycle Mngmt
- Securing HANA System
- User Provisioning
- Authentication Methods
- Auditing Activities
- Backing Up HANA System
- Recovery HANA System
- HANA XS Application Service
- Data Provisioning
- Smart Data Access
- New Remote System Connection
- Integration with Hadoop
- Key Commands
- Job Responsibilities
- SAP HANA Admin Useful Resources
- SAP HANA Admin - Quick Guide
- SAP HANA Admin - Useful Resources
- SAP HANA Admin - Discussion
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
SAP HANA Admin - Overview
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.
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.
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.