A SAP HANA administrator can start tenant databases either individually, or it can also be done once by starting the whole system and same is for stopping the database.To perform this, navigate to SAP HANA Cockpit -> Open the Manage Databases app -> You have to select tenant database that you want to stop or start -> Select stop Tenant Database or start Tenant Database in the footer toolbar.The database starts stopping or starting and will be completed in few minutes.

In following scenarios. When you open Administration editor, it is opened automatically in diagnosis mode:When you open the Administration editor for a system without an SQL connectionWhen you initiate the start, stop, or restart of a systemYou can also open diagnosis mode manually by navigating to following path:

To perform stop and start individual database services (nameserver, indexserver, xsengine and so on) running on an SAP HANA host or hosts, you should have system privilege SERVICE ADMIN.

In Services tab under Landscape, you can right click on any service name and select Start Missing Service. This service activates any inactive service in your HANA system.

Stop...The service is stopped normally and then typically restarted.Kill...The service is stopped immediately and then typically restarted.

Yes, you can start/stop a particular service of HANA system. To stop a service, go to Administration editor → Services tab. Right-click the service and choose the required option:

You can also stop HANA system by setting date and time and this comes under Soft stop.In case you don’t shut down the system before the specified timeout, it is shut down forcefully.

To stop a HANA system, right-click the system you want to stop and choose Configuration and Monitoring → Stop System…Following options are available when you stop a system −Soft − The system is stopped after all running statements have finished or the specified timeout is reached.Hard − The system is stopped immediately. Open transactions are aborted and rolled back.

In SAP HANA studio, you can start/stop SAP HANA system. In a system with multitenant database containers, all tenant databases will be started except those that were individually stopped. To perform start/stop, right click on HANA system → Configuration and Monitoring → Stop System…

Start, Restart, Stop System Operations: To perform start/stop/restart of HANA systemDiagnosis Files: This is used to access log, trace and other diagnosis files.Troubleshoot Unresponsive System: You can use this to trigger the collection of transactional information and displays this information for troubleshooting performance issues.SAP HANA Documentation - SAP HANA Offline Administration: You can open SAP HANA documentation that describes those administration tasks that you can perform using the SAP HANA cockpit for offline administrationSAP HANA Cockpit: This option is used to open SAP HANA cockpit where you can access all applications for the online administration of SAP HANA system.Read More