Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
SAP Articles
Page 41 of 91
Component Name in SAP HANA architecture
The following table lists all the key server components in HANA, the corresponding services, and OS process details.
Read MoreIndex server in SAP HANA system
Index server contains SQL/MDX processor to handle query statements for the database. When SQL or MDX is fired for SAP HANA system, an Index Server takes care of all these requests and processes them. All HANA processing takes place in Index Server.Index Server contains Data engines to handle all SQL/MDX statements that come to HANA database system. It also has Persistence Layer that is responsible for durability of HANA system and ensures HANA system is restored to most recent state when there is a restart of system failure.Index Server also has Session and Transaction Manager, which manage transactions and keep ...
Read MoreChecking topology of SAP HANA
The topology of SAP HANA system is maintained by Name Server. This is used to manage all the running components and data stored in each component.
Read MoreManual compression of a table in SAP HANA
It is also possible to compress a table in SAP HANA system manually by executing the following SQL statement.UPDATE "table_name" WITH PARAMETERS ('OPTIMIZE_COMPRESSION' = 'YES')This results in deciding whether a compression is required or an existing compression can be optimized. In this scenario, HANA system uses most suitable compression algorithm.When you run the above SQL command, compression status remains the same. You can also force the database to reevaluate compression using the following SQL status UPDATE "AA_HANA11"."SHOP_FACTS" WITH PARAMETERS ('OPTIMIZE_COMPRESSION' = 'FORCE')
Read MoreCommon system schema in SAP HANA Studio under Provisioning
Common system schema are −_SYS_BIC_SYS_REPO_SYS_BI_SYS_XS_SYS_STATISTICS and many more
Read MoreRemote system allowed in SAP HANA Smart Data Access
In SAP HANA SPS07, it has been extended to MSSQL server and Oracle database and write operation was permitted to perform on remote data sources.Following remote systems are allowed under Smart Data Access with Write operation in SAP HANA SPS07 −SAP HANASybase ASESAP Sybase IQTeradata 13.0 or higherApache Hadoop 2.3MSSQL 11Oracle 12c
Read MoreUsing SAP HANA SPS06 vs SPS07 with Smart Data Access SDA
In below table, you can see the list of remote data sources that are supported under SAP HANA Smart Data Access for SPS06 and SPS07 and the operations supported −SAP HANA VersionsSPS06SPS07 or higherSupported Data Sources under Smart Data AccessSybase ASE, SAP Sybase IQ 15.4 ESD 3 and Version 16.0 Apache Hadoop Version 2.3 Teradata Database Version 13.0 or higherSybase ASE, SAP Sybase IQ 15.4 ESD 3 and Version 16.0 Apache Hadoop Version 2.3 Teradata Database Version 13.0 or higher Oracle database 12c MSSQL version 11 for SQL Server 2012 IBM DB2Operations SupportedSelectSelect, Insert, Update and Delete
Read MoreAdapters supported under Smart Data Access in SAP HANA
Below is the list of Adapters which are supported under Smart Data Access in SAP HANA −This comes while creating a new Remote Data Source.
Read MoreDifferent database objects inside Catalog folder in SAP HANA Studio
It includes −Column ViewsEPM ModelsEMP Query SourceFunctionsIndexesProceduresSequencesSynonymsTablesTriggersViews
Read MoreTime taken by savepoint to perform backup in SAP HANA
M_SAVEPOINTS view stores Current and historical savepoint statistics. There is column DURATION which tells the total time taken by savepoint.You can extract the following information from the numbers in this view −CRITICAL_PHASE_DURATION shows the period of time during which the updaters were blocked in a savepoint. Normally, this should be in the milliseconds range, except for a global savepoint for data backup, which may take longer due to global synchronization across all nodes. If the critical phase duration is too long, there is probably some problem (e.g., I/O load is too high).DURATION shows the total time taken by a savepoint. ...
Read More