How to Identify Whether SAP HANA is Single or Multi Container Mode?

SAP HANA is running in Single Container or Multi-Container mode

you can follow these steps:

1. Log in to the SAP HANA system using the appropriate credentials. You need administrator or superuser privileges to perform the following steps.
2. Open the SAP HANA Cockpit or the SAP HANA Studio, depending on the version and setup of your SAP HANA system.
3. In SAP HANA Cockpit:

• Go to the "Databases" section.
• Select your SAP HANA database instance from the list of databases.
• Look for information about the containers. If it is running in Multi-Container mode, you will see multiple container entries, each representing a different container. In Single Container mode, there will be only one container entry.

1. In SAP HANA Studio:

• Connect to your SAP HANA system.
• In the "Navigator" or "Systems" view, expand your system to see the database instances.
• Expand the database instance, and you should see the containers listed underneath it. If there are multiple containers, then it is running in Multi-Container mode. If there's only one container, then it's running in Single Container mode.

1. Using SQL Command:

• Open a SQL console (e.g., SQL Command Editor in SAP HANA Studio).
• Execute the following SQL query to check the number of containers:

SELECT COUNT(*) FROM SYS.M_SERVICES WHERE SERVICE_NAME LIKE '%indexserver%';         

• If the result is 1, then it is running in Single Container mode. If the result is greater than 1, then it is running in Multi-Container mode.

Please note that Multi-Container mode is typically used in scale-out scenarios, where SAP HANA can distribute data and processing across multiple nodes (servers). Single Container mode is used in single-node deployments

Another Method

Starting SAP HANA 1.0 SPS 09 (Revision 90), SAP HANA supports multiple isolated databases or multitenant database containers in a single SAP HANA system.

Starting SAP HANA 2.0 SPS 01 (Revision 10), multitenant database containers will become the default and the only operation mode, refer to SAP Note 2423367 – Multitenant database containers will become the standard and only operation mode.

Open transaction code DB02, and click on Overview under Current Status. See the Multitenant database container line. If it’s a Yes, then it is multi-container. Else, single container.

For reference sap notes

• 2101244 – FAQ: SAP HANA Multitenant Database Containers (MDC)
• 2423367 – Multitenant database containers will become the standard and only operation mode

For understanding MCOS and MCOD architecture please visit the article

Please connect and?follow?me for the next upcoming informative articles.

Cheers :)