How I Start and Stop SAP HANA Tenant Databases — My Go-To Methods

 Managing SAP HANA tenant databases is something I’ve had to do regularly, especially during system maintenance or troubleshooting. Whether you're using command-line tools or graphical interfaces, the process is pretty straightforward once you get the hang of it.

🖥️ Using the Command Line

When I’m working directly on the server, I prefer using the HDB command. It’s quick and reliable.

• To start a tenant database, I use:

  Code

  hdbsql -i <instance number> -u SYSTEM -p <password> "ALTER SYSTEM START DATABASE <tenant_name>"
  

• To stop a tenant database, I run:

  Code

  hdbsql -i <instance number> -u SYSTEM -p <password> "ALTER SYSTEM STOP DATABASE <tenant_name>"
  

These commands are executed via hdbsql, SAP’s SQL command line tool. You’ll need the correct instance number and credentials, of course.

🧪 Using SAP HANA Studio

If I’m in a GUI mood or working remotely, SAP HANA Studio makes it easier:

• I right-click on the system database connection, then navigate to the “Configuration” tab.

• Under the “Landscape” view, I can see all tenant databases listed.

• From there, I right-click on the tenant I want to manage and choose either “Start” or “Stop”.

It’s visual, intuitive, and great for monitoring the status of multiple tenants at once.

🧭 SAP HANA Cockpit (Optional)

In some setups, I’ve also used SAP HANA Cockpit — a web-based interface. It allows you to:

• View tenant status

• Start/stop tenants

• Monitor performance and alerts

Though not always available in every environment, it’s a solid option when configured.