SAP Hana Database Over view

What’s SAP HANA DATABASE?

What’s SAP HANA and Hana information?

In This blog, we will explained the SAP Hana Database Over view , Hana Parameter, backup location path and Hana Trace file path and performance trace files details.

Topics for SAP Hana Database Over view:

• • • What is SAP HANA
    • Hana Parameter and configuration files
    • Hana Backup location
    • Hana Lock file location
    • Hana trace file location
    • Hana performance traces file location

What’s SAP HANA?

• SAP HANA (High-performance Analytic Appliance) is a revolutionary database that brings speed and intelligence together!
• Instead of traditional storage on disks, SAP HANA keeps data right in the computer’s memory – making it blazingly fast and perfect for real-time analytics.

Why In-Memory Matters:

• Unlike traditional databases, in-memory databases (IMDBs) store data directly in RAM, enabling ultra-fast data retrieval.
• This makes SAP HANA ideal for industries that need instant data processing, like banking and telecom, and supports real-time analytics, predictive modeling, and more!

SAP HANA’s Speed Stats:

• 3,600x faster than traditional databases
• Answers queries in under a second
• Scans 3.5 billion records per second per core
• Handles 15 million aggregations per second per core

Top 10 Benefits of SAP HANA:

1. Complete: Includes database, analytics, app development, and integration
2. Fast: Answers complex queries in under a second
3. Versatile: Supports both transactional & analytical processes
4. Efficient: Minimizes data duplication and enhances compression
5. Powerful: Uses massively parallel processing (MPP) for large datasets
6. Scalable: Grows easily with your data and user needs
7. Flexible: Available on-prem, cloud, or hybrid
8. Simple: One gateway for all your data
9. Intelligent: Integrated with machine learning
10. Secure: Built with robust security measures

SAP HANA’s architecture is designed for high-speed transactions, advanced analytics, and flexible data management – empowering businesses to be truly data-driven.

Once you have understand the SAP HANA DATABASE concept, then go for further Process of the Hana administrator Tasks.

Please check below Blogs for Hana Administrator Tasks.

1.Hana database Consistency check Part1 and Part2
2. Hana database upgrade From Hana1.0 to Hana2.0
3. Hana database installation
4. Hana cockpit installation
5. Hana database Fast restart option
6. Hana log Full situation resolution steps
7. Hana database Backup Configuration
8. Hana database issue troubleshooting Part 1

Hana Parameter and Configuration Files details:

Please check below Hana Parameter is Host specific parameter and Global parameter(All hosts)

• The location of the configuration files : xxxx.ini files has exist in below path
• This is for Host specific parameter path
• /usr/sap/<sid>/HDB<instance number>/<server name>
• Below path is globally changed parameters (i.e. for all hosts)
• / usr/sap/<sid>/SYS/global/hdb/custom/config
• Below path is the parameters with default values/usr/sap/<sid>/HDB<instance number>/exe/config
  Parameter files:
  ini -global
  ini -Instance & Host
  ini-default
• host specific changed parameters:daemon.ini,global.ini & sapprofile.ini–>/usr/sap/<sid>/HDB<instance number>/<server name>
  Instance specific parameters parameters:
• indexserver.ini
• nameserver.ini
• xsengine.ini
• statisticserver.ini
• compileserver.ini

/usr/sap/<sid>/HDB<instance number>/exe/config
/usr/sap/<sid>/SYS/global/hdb/custom/config

Hana Memory:

• We can check the Hana used memory in Hana studio and Hana Cockpit
• Please execute the below command for check global allocation limit
  Command:
  check–>
  select * from m_inifile_contents where file_name like ‘global.ini’ and key = ‘global_allocation_limit’;

Hana Database useful information to analysis the logs

Please check the below SAP note for Collecting diagnosis information for SAP HANA

1732157 – Collecting diagnosis information for SAP HANA

Diagnosis files:

In the Administration Editor in HANA Studio, choose the Diagnosis Files tab. If the system is offline, the Administration editor opens in diagnosis mode:

Choose Diagnosis Information >

Collect Select whether System Views should be included (in earlier HANA revisions this option was offered in the step before by choosing “Collect with SQL” or “Collect without SQL) and the date range for which you want to collect the diagnosis information.
Click the “Finish Button” to trigger the collection of diagnosis information
See below section ‘Where to Download’ to download the collection

$DIR_INSTANCE/global/sapcontrol/snapshots
/usr/sap/HA4/SYS/global/sapcontrol/snapshots

We can execute the and collect the diagnosis /Full DUMP information on OS level.
got to directory $DIR_INSTANCE/exe/python_support
Execute the below command for generate the Full Dump.

python py -t SID –days=30

Please find the below files location Path:

messages file location:

• cd /var/log/messages

performance trace location:

• /usr/sap/HA4/HDB**/hostname/trace
  The trace files of the each host in the landscape location i.e.
• $DIR_INSTANCE/<SAPLOCALHOST>/trace/.

HANA Trace file location:

• /usr/sap/SID/HDBXX/hostname/trace

HANA lock file location:

• /usr/sap/SID/HDBXX/hostname/lock

HANA Backup location:

• /usr/sap/SID/HDBXX/backup

HANA Configuration file location:

• /usr/sap/SID/HDBXX/exe/config

HANA backup size/space estimation

• SELECT SUM(allocated_page_size) FROM M_CONVERTER_STATISTICS;

Conclusion :

In This blog, we will explained the SAP Hana Database Over view , Hana Parameter, backup location path and Hana Trace file path and performance trace files details.

SAP Hana Database Over view

Other information:

SAP Hana database Latest version is Hana2.0 SP7.

If your SAP HANA database has running on Hana1.0 database then you can upgrade to Hana2.0 Database.

Please check other Posts for SAP Hana Database Over view and installation, upgrade and SAP HANA Replication configuration and steps