Hi Friends,

Please find Hana database alert details below for your reference. 

List of task/activity can perform on System database and tenant database.

 Hi Everyone,

In this blog, we are going to see different activities, which can perform on the System database and tenant database. 

It is important to know which activity we can perform on the system and tenant database, as in critical time it helps to save time.

An SAP HANA system comprises multiple isolated databases and may consist of one host or a cluster of several hosts. An SAP HANA system is identified by a single system ID (SID) and contains one or more tenant databases and one system database.

An SAP HANA system is capable of containing more than one tenant database.

A system always has exactly one system database, used for central system administration, and any number of tenant databases (including zero). An SAP HANA system is identified by a single system ID (SID). Databases are identified by a SID and a database name. From the administration perspective, there is a distinction between tasks performed at the system level and those performed at the database level. Database clients, such as the SAP HANA cockpit, connect to specific databases.

All the databases share the same installation of database system software, the same computing resources, and the same system administration. However, each database is self-contained and fully isolated with its own:

 

1. Set of database users
2. Database catalog
3. Repository
4. Persistence
5. Backups
6. Traces and logs

Although database objects such as schemas, tables, views, procedures, and so on are local to the database, cross-database SELECT queries are possible. This supports cross-application reporting, for example.

Things to Remember About the System Database

1. The system database does not have the same functionality as a tenant database.
2. The system database is not a database with full SQL support.
3. The system database cannot be distributed across multiple hosts, in other words, scale-out is not possible.
4. If you need a full-featured SAP HANA database, you always have to create at least one tenant database.
5. The system database does not support Application Function Libraries (AFL) and SAP liveCache applications.
6. Cross-database access between the system database and a tenant database is not possible. The system database can show monitoring data from tenant databases (views in the schema SYS_DATABASES) but can never show actual content from tenant databases.
7. The system database cannot be copied or moved to another host.
8. SAP HANA options can only run in tenant databases.
9. Tenant-specific configurations cannot be set in the system database. Only global settings are allowed.
10. Features can only be restricted or disabled at a high level for tenant databases.

The system database is created during either installation or conversion from a single-container system to a tenant database system. The system database contains information about the system as a whole, as well as all its tenant databases. It is used for central system administration.

Thanks 

Rupesh Chavan

Regular/Daily HANA Administration Tasks- IMP

 Hi Everyone,

This we are going to see regular administration tasks of HANA Database admin.

Monitor the health of your SAP HANA system using, for example, the SAP HANA Studio/ SAP HANA cockpit. The most important system information to review is:

1. Overall system status
2. Status of database services, for example, name server, and index server
3. General system information (software versions and so on)
4. Alerts generated by the statistics service
5. Usage of important system resources: memory, CPU and disk
6. Perform regular data backups, including configuration backups. There are no specific guidelines for backup frequency, which depends on the usage scenario
7. Avoid the log backup area becoming full by archiving old log backups to a different location.

8. Monitor disk space used for diagnosis files and delete files that are no longer need

The above-given tasks are an essential task/monitoring need to perform on the HANA database on daily basis to avoid database-related issues. 

Thanks 

Rupesh Chavan

HANA Database free guide and books

 Hi Guys,

In this blog, we are going to see free books of the HANA database that we can download if we have an S id to login on to the SAP support portal

1. SAP HANA Administration Guide
2. SAP HANA Troubleshooting and Performance Analysis Guide
3. SAP HANA Tenant Databases Operation Guide
4. SAP HANA Master Guide
5. SAP HANA SLQ and System views reference
6. Administration Guide for additional SAP HANA Capabilities

These are the books, which help us to learn new/old updates and functionality of the HANA Database.

Thanks 

Rupesh Chavan