SAP HANA Database Administration

What kind of database is SAP HANA?

Which database does SAP S/4HANA run on?

How do database groups control access in the SAP HANA cockpit?

What type of database is SAP HANA, and what properties give it high performance?

How does SAP HANA multitenancy work, and what is the difference between the system database and a tenant database?

What is the difference between a soft shutdown and a hard shutdown in SAP HANA?

What are the two top-level directory areas for SAP HANA on Linux, and where do the actual files reside?

Where are SAP HANA trace files located and what is their naming convention?

How do you start or stop an individual SAP HANA tenant database, and which database must you connect to?

What is the difference between SAP HANA standard trace files and alert trace files?

How are SAP HANA data and log volumes organized on disk, and why must their files never be touched manually?

What role does hdbdaemon play in the SAP HANA process hierarchy?

What port numbering scheme does SAP HANA use, and which port ranges are for SYSTEMDB vs tenant databases?

What command-line tools start and stop the SAP HANA system, and when should each be used?

What privileges and password requirement apply to the SAP HANA cockpit technical user?

How many SYSTEM databases does an SAP HANA system have, and can it be distributed?

If you stop an individual HANA service, why might it come back automatically?

What is the SAP HANA cockpit used for?

How do you stop a single HANA tenant database with SQL?

Which aspects of a tenant database are fully isolated from other tenants?

What is the precedence order of SAP HANA configuration layers, from lowest to highest?

What is the deprecation status and maintenance scope of SAP HANA Studio?

What are the main steps of the SAP HANA startup sequence?

What do all databases in one SAP HANA instance share?

What is the setParameter.py tool used for in SAP HANA?

What is the difference between a differential and an incremental delta backup in SAP HANA?

Which Eclipse perspective must an administrator switch to in SAP HANA Studio?

What is the role of the SAP HANA index server (hdbindexserver)?

What does the sapcontrol function GetSystemInstanceList report in a multi-node SAP HANA system?

When stopping the entire HANA system, what is the difference between a soft stop and a hard stop?

Why is it recommended to give the HANA instance and its tenant databases different SIDs?

When would you use hdbcons in SAP HANA?

What does an SAP HANA multitenant system consist of?

What is the SAP HANA script server (hdbscriptserver) used for?

What is the advantage of backing up SAP HANA with a storage snapshot?

Which HANA services run in the SYSTEM database and serve all tenants?

What is a savepoint in SAP HANA, and how often does one occur by default?

Why is restoring delta backups faster than replaying log backups?

What is the delta merge in SAP HANA?

How does dictionary encoding compress data in the SAP HANA column store?

What does the hdbsql inline command \align (\al) do?

How do you run an hdbsql script unattended with a user store key?

Why does row-based storage perform poorly for analytical queries that scan one column across many rows?

What is the role of the name server (hdbnameserver) in SAP HANA?

Which command starts and stops a distributed (multi-host) SAP HANA system, given that HDB cannot?

After a HANA crash, how is the database brought back to a consistent state?

At what allocation percentage do the DBA Cockpit memory/CPU bars turn red by default?

How does SAP HANA soften the slower-write trade-off of the column store?

In SAP HANA, how are configuration parameters organized within the .ini files?

What do the hdbsql connection options -i, -n, -d, -u, -p, and -U mean?

Why is a takeover by a HANA replication secondary fast in terms of performance?

What is Backint in the context of SAP HANA backups?

Which database administration jobs can be scheduled from the DBA Planning Calendar in DBA Cockpit?

How does a column store make large analytical scans fast?

What does the HDB command-line script let a <sid>adm user do?

What do the green, yellow, and red labels in the DBA Planning Calendar mean for a backup?

What does multitier system replication enable in SAP HANA?

What does the Backup Catalog in DBA Cockpit Diagnostics show?

What is the SAP HANA secure user store (hdbuserstore)?

What are the four main tools used to manage SAP HANA?

Where is the hdbsql executable installed on a SAP HANA system?

How do you disable autocommit in hdbsql?

What does the HANA daemon process (hdbdaemon) do?

Even with hdbsql session autocommit off, why can a CREATE or DROP TABLE still not be rolled back?

Which databases can DBA Cockpit (DBACOCKPIT) manage?

What is the SYSTEM database in SAP HANA responsible for?

When a column-store table is read, why must HANA also check the delta store?

When is a HANA log segment automatically backed up?

On a HANA replication secondary, what are the two log-replay operation modes and their trade-off?

How is a single SAP HANA instance identified?

Which operating-system user does the SAP HANA cockpit need in order to start/stop and restore the system?

Why is the SYSTEM database not suitable for running business operations?

Why does an in-memory database like SAP HANA still need a persistence layer?

How are transaction changes protected between savepoints in SAP HANA?

When are performance indexes still recommended for SAP HANA column-store tables?

Why is persisting data to disk alone not enough to fully protect SAP HANA data?

How does adding a new tenant database interact with system replication?

In what order is an SAP HANA database recovered when using full, delta, and log backups?

Are SAP HANA database backups taken online or offline?

What is the Database Overview page in the SAP HANA cockpit?

How are remote databases added to DBA Cockpit for central management?

In SAP HANA system replication, what is the basic flow from primary to secondary?

Where are SAP HANA configuration files physically stored?

What distinguishes synchronous from asynchronous system replication, and what is the cost of synchronous?

What are the practical limits of SAP HANA Studio now that it is deprecated?