When you add a new system under HANA Studio, below screen comes where different folders are available to manage HANA system. To open SQL editor, you have to select HANA system and click on SQL button at the top.Once you click on SQL button to open SQL console for selected items, right side you can see a SQL editor where you can run SQL queries in HANA database.You can also open SQL console by right click on HANA system HDB → Open SQL Console. When console is opened, at the top you can see host name and instance number and ... Read More

The cross database container access is managed in Global.ini file in Configuration under System Administration.To access global.ini file you need to navigate to Administration tab in HANA Studio → Configuration and there you can find Global.ini file.

SAP HANA also supports multitenant database container system, along with singe logical database. Using multitenant isolate databases, administration of HANA system becomes easy in a distributed environment.You can also implement cross tenant database structure where one application running on one HANA system can also run on logical database from other container system or two applications can use same single logical database hosted on different HANA systems.

If you open SAP HANA cockpit, you can see different database functions in the HANA system − https://best:4303/sap/hana/admin/cockpit

SAP HANA system combines OLAP and OLTP processing into a single in-memory database and it removes the disk bottlenecks and offering groundbreaking performance. This ACID-compliant, in-memory columnar database stores provides data compression up to 11 times as compared to other conventional database, parallel processing across multiprocessor cores, and supports single instruction multiple data (SIMD) commands.

All the database objects in SAP HANA system are maintained in the CATALOG folder in HANA Studio. Following are the key capabilities of SAP HANA database system −You can use a high-performance in-memory database for processing complex transactions and analytics. You can manage large database volumes in multitenant database containers.Using SAP HANA in-memory database component, you can run advanced analytical queries that are complex in nature that too with high-speed transactions to get the correct, up-to-date responses in a fraction of a second. SAP HANA in-memory db system removes the need of predefined aggregates, materialized views, and removes data duplicity ... Read More

Statistics server is used to manage health of your HANA system. You can take information related to status, performance consumption of resources from all the servers in your system landscape. You can also pull the reports related to performance of server components for analysis.

Preprocessor server provides text data analysis and search capabilities in HANA system. Preprocessor server is used by Index search to analyze the text data and to perform any search on the text data. This server is used to extract the information based on text search capabilities in HANA system.

In SAP HANA system architecture, Name server is used to maintain topology of SAP HANA system. It details complete information about system landscape- all hosts in distributed environment, active components and services running on each component in a distributed system environment.Topology details of SAP HANA system is maintained.Name server holds the detail of each component and services running on each host and hence reduces the re-indexing time.

In SAP HANA system architecture, Name server is used to maintain topology of SAP HANA system. It details complete information about system landscape- all hosts in distributed environment, active components and services running on each component in a distributed system environment.You can check service start time, memory used, CPU used, Process Id, port number and other details for each service under each component in your environment.When you navigate to System Administration → Landscape tab of your HANA system, all the information provided there- Services, Hosts, Redistribution and System Replication information is relevant to landscape information.You can check the status of ... Read More