Basis Technology

A few weeks ago, we discussed how an SAP system could be set up to be “externally-signed”, i.e. trusted so that the system is truly what someone may claim it to be.  This is the root of all SSL trust relationships. Now that we have set... Read More »

M_EXPENSIVE_STATEMENT Vs MEMORY_SIZE,CPU_TIME,DURATION_MICROSEC   If you are a HANA DBA and you want to find out SQL statements that are consuming a very huge memory or CPU or or duration, the first point to examine is table... Read More »

HISTORIC RECORD COUNT USING _SYS_STATISTICS.HOST_COLUMN_TABLES_PART_SIZE If you have ever wondered how to find the historic row count of any column store table in HANA, this email will help you out! WAY1 :Execute the below SQL which uses... Read More »

Simple but Important commands in HANA DB on M_TABLE_PERSISTENCE_STATISTICS Vs M_TABLES Vs M_CS_TABLES   A.Different use cases of using M_TABLE_PERSISTENCE_STATISTICS 1.Wanted to find the disk size of your HANA DB select... Read More »

BW Active table Vs BW New table in scale out ; How to avoid inconsistent DSO in BW   Though re-partitioning BW table is like normal table re-partition in HANA, but there are few special consideration that have to be taken care during planning... Read More »

RE-PARTITIONING HANA COLUMN TABLE USING COPY,REPLACE and MINUS functionality   Here I wish to discuss about how we performed a partition of table by using an empty clone of the existing table and later had synced both the table to overcome... Read More »

Business Configuration Set (BC Set) In the R/3 system from SAP, a Business Configuration Set (BC Set) is a management tool that allows the user to record, save, and share customized settings. By creating a BC Set, the user is provided with a... Read More »

CROSS-TENANT DATABASE QUERIES: Below is the simple question and answer format to get an easy understanding as of how to make use of cross-tenant database... Read More »

A transition to SAP S/4HANA is on everyone’s agenda. Sooner or later you will start your journey to SAP S/4HANA. In such projects you deal with longer runtimes. As a result there are troubles meeting the requested downtime window by the business... Read More »

OWNERSHIP CONCEPT Vs ROW STORE TABLE MOVE: In this blog i wish to discuss one of the ownership related issues involved when moving a row store table between nodes in a scale out setup. As a general recommendation and for better performance in HANA,... Read More »