SAP HANA Database Administration

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

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

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

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

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

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

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

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

What kind of database is SAP HANA?

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

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

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

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

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

What is the SAP HANA cockpit used for?

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

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

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

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?

What do all databases in one SAP HANA instance share?

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

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

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

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?

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

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

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

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 are the two top-level directory areas for SAP HANA on Linux, and where do the actual files reside?

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

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

What is the delta merge in SAP HANA?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

When is a HANA log segment automatically backed up?

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

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

What is Backint in the context of SAP HANA backups?

How do you disable autocommit in hdbsql?

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

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

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

How does a column store make large analytical scans fast?

What is the SYSTEM database in SAP HANA responsible for?

How are transaction changes protected between savepoints in SAP HANA?

Where are SAP HANA configuration files physically stored?

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

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

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

Which databases can DBA Cockpit (`DBACOCKPIT`) manage?

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

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

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

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

What does the HANA daemon process (hdbdaemon) do?

Which database does SAP S/4HANA run on?

Are SAP HANA database backups taken online or offline?

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

What does multitier system replication enable in SAP HANA?

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

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

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

What does the Backup Catalog in DBA Cockpit Diagnostics show?

How is a single SAP HANA instance identified?

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