SAP HANA, express edition

Most frequently executed statements in HANA DB per application: If you want to find out what are the frequently executed statement or query or a view in HANA  per client which connects to HANA DB ,below SQL will help with the same . Here I am... Read More »

SQL statement Vs SQL’s Statement HASH: In HANA, in many places we would have seen the column called STATEMENT_HASH,STATEMENT_ID etc .Hence if we want to find out the underlying SQL associated with the STATEMENT_HASH below information will help... Read More »

TABLE and SQLs running on this table If you wanted to know how to find out the list of statements that got executed on any table within a week or so,and who executed it,when it got executed etc  you can use the below SQL. select statement_string,... Read More »

ACTIVE STATEMENTS OF HANA DB: 1.Below SQL will help with the list of currently running statements in HANA along with its memory usage, runtime since its cursor was open, is some blocked transactions are involved, which SQL statement, which DB and... Read More »

HANA Garbage Collection block=>Column Store version consolidation. If you are a HANA DBA and are facing issues with system performance, Garbage collection is one of the area where we might have to look and check for any GLOBAL block. Another type... Read More »

CONVERTING BETWEEN ROW STORE TO COLUMN STORE TABLE Do you want to find out if there are any ROW store tables that were created accidentally in HANA and convert it into column store ? Use select on M_RS_TABLES with a where clause on SCHEMA_NAME. Eg:... Read More »

Performance trace Vs HANAAdmin tool If you have tried to collect a performance trace , and have ended up in a file *.tpt which is not human readable, note that performance trace can be decoded by using a tool called HANAAdmin. Below information is... Read More »

Altering HANA behavior at peak load using Admission Control in HANA 2.0 Below are the details which helps us understand how HANA 2.0 uses admission control to handle higher system load in a simple question and answer format. Hope it helps! NOTE:You... Read More »

Relationship between Tables,locks and workprocess Below blog consists of two section: a.To find out if there are any table lock on any table in HANA DB b.Relationship between SAP work process and client ip which is holding locks in DB level  for a... Read More »

HIGHER STATEMENT_MEMORY_LIMIT ADVERSE AFFECTS ON HANA DB: As you all know, in HANA, As soon as peak memory gets hit, column store tables will be unloaded to process further new table load request based on LRU.ie, in the below screen shot, column... Read More »