Administration Tools: Cockpit, Studio & Command Line

What is the most common silent failure of the SAP HANA cockpit monitoring (technical) user, and what minimal privileges does it actually need?

You need to browse the catalog, run ad-hoc SQL across multiple connections, and open trace files in one place. Which HANA tool fits, and what is its hard prerequisite?

The HANA instance is up at the process level but no longer answers SQL. Which tool do you reach for, and why does it work when the others don't?

A colleague has the Cockpit User Administrator role and asks why they can't register a new database. What is the role boundary they're hitting?

Since SAP HANA 2.0, which tool is SAP's recommended default for landscape-wide administration, and how can it be deployed?

In hdbsql/the SQL console, statements are case-insensitive — so what breaks if you create an object with double quotes and later reference it without them?

When stopping a HANA system under time pressure, what is the real cost difference between a soft stop and a hard stop?

You want to limit a cockpit user to one database group. Why might granting them a database administrator role defeat that, and what's the rule?

Using sapcontrol on a multi-node HANA system, which function tells you the local service status versus the state of every host and its role?

How do you stop a single HANA tenant database, and from where must the command be issued?

Beyond tidiness, what does a SAP HANA cockpit database group actually control, and where do autogenerated groups come from?

Given HANA Studio's deprecated status, what specific tasks will it silently fail to do, pushing you to SQL or the cockpit?

Connecting with hdbsql, which option names the specific database to target, and why prefer -U over -u/-p?

On a distributed multi-host HANA system, why is HDB start the wrong tool, and what do you use instead?

A HANA instance won't start and you must change a config parameter to recover it. Which tool works when SQL doesn't, and how do you target the layer?

In HANA Studio, a DBA is chasing blocking and expensive statements. Which perspective and tab area do they open?

Which command-line tool configures HANA system replication, and which one lets a client connect by key without a password in the command?

Your backup catalog is lost and you must work out which data/log backups a recovery needs. Which tool do you run, and how does it differ from hdbbackupcheck?

A new tenant doesn't appear for monitoring in the cockpit. At what level must registration happen, and why is that the cause?

On disk, how do you tell HANA's system-wide config files apart from a single tenant's config files?

Is a HANA system's usage type just a descriptive label, and how is it set?

You set a HANA parameter at the SYSTEM layer but a tenant ignores it. Given the layer precedence, what's the likely cause?

In what order does SAP HANA restore tenants to an operational state on startup, and at which step does the database become available?