When a tenant database is unavailable due to some performance problems, the tenant database administrator can't access diagnosis files. In this case, a system administrator can access the diagnosis files of the tenant database from the system database using the SAP HANA studio.In the SAP HANA studio, open the Administration editor and choose Diagnosis Files and diagnosis files of the system database are displayed.Using the Database filter, select the tenant database → whose diagnosis files you want to see and diagnosis files of the selected tenant database will be displayed.

Yes, it is possible to remove a server component, which are no longer required. This can be performed using ALTER DATABASE SQL command.Following perquisites should be met to perform this task −You are logged on to the system database.You have the system privilege DATABASE ADMIN.To remove a service, you need to open SQL console of the SAP HANA studio and run “ALTER DATABASE” statement.ALTER DATABASE DB1 REMOVE '' AT LOCATION 'HOST_A:30XXX'

Following are the main services that you may need to add to a tenant database:indexserverxsenginescriptserverdpserver

To scale out a tenant database and/or distribute it across multiple hosts, you can add further server components, for example, an additional index server or a separate XS server. You add a service to a tenant database using the ALTER DATABASE SQL command.You do this from the system database using the following command −ALTER DATABASE ADD Following perquisites should be met to perform this task −You are logged on to the system database.You have the system privilege DATABASE ADMIN.

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: