About HermannGahm

HermannGahm

Hi, more than 10 years ago i wrote a couple of blogs on ABAPperformance tracing with ST12 (see below). The performance tools in ADT and the tools for SAP GUIin the SAP standard (STATS, SAT, ST05 and SCI) arealways available and particularly good in ...

HermannGahm

After finishing this , we can continue our series.We'll start with some background information of the column store that will help us to better understand the guidelines introduced by eric.westenberger.It is often mentioned that SAP HANA uses an „inse...

HermannGahm

I recently delivered a service (ABAP OPEN SQL Optimization)for a customer and the customer asked me: “What’s the upper limit of indexesper table”. Three possible answers came immediately to my mind:32767; since that was the technical limit on that DB...

HermannGahm

Try to remember, when was the last time you got a question andyou invested some time (and enjoyed it) to provide an answer? What were thecharacteristics of the question? Was it a specific or rather unspecific question?Was the question well prepared a...

HermannGahm

Consultants or Support Consultants like me know this situation quite well: You are at a customer and you are asked to trace and analyze a background job which runs outside of office hours e.g. from 04:00 am to 04:30 am. This blog will show you how to...

HermannGahm

Hi Sandra,thank you.In the output you can see the difference in the allocation sequence.Dialog processes use up to 2000000000 EM and after that is used 2000000000 HEAP.Background processes do it the other way round (first HEAP then EM).So if you see ...

HermannGahm

Hi Sandra,> I'd like to understand why Heap is used although EM is only few hundreds of MB and no other task in the system.can you post the output of RS MEMORY? HEAP Memory for DIALOG processes is used when EM Quota is reached. it is workprocess loca...

HermannGahm

Hi, have you checked if the statement wise trigger fits your needs? (see https://help.sap.com/docs/HANA_SERVICE_CF/7c78579ce9b14a669c1f3295b0d8ca16/20d5a65575191014946db96aaedbef5b.html)

HermannGahm

Hi Sandra, like Ryan i think as well the intermediate format and the higher flexibility of XSLT have their price regarding memory and performance. Batch processes can't go priv, they typically use heap memory before they use EM (see report RSMEMORY f...

HermannGahm

Hi Sandra,if you execute the trace without aggregation you can see the relationship in the call hierarchy:The DB FETCH Operations are children of the FETCH Operation.In my case the FETCH Operation took 22249 µs and the DB Fetch Operations 21743 µs (1...

User Statistics

User Activity

Question: Is ABAP performance tracing (ST12) still a topic?

HANA column store backgrounds (INSERT ONLY)

What’s the (practical) upper limit of indexes per table?

The quality of an answer depends significantly on the quality of the question (or: how to ask good questions)

ST12 - Schedule Traces

Re: Big memory consumption XSLT, why Heap is used? Best with ST.

Re: Big memory consumption XSLT, why Heap is used? Best with ST.

Re: Insert ROW-TYPE variable into table without explicitly typing all column names

Re: Big memory consumption XSLT, why Heap is used? Best with ST.

Re: What's the meaning of "DB: Fetch" versus "Fetch" in S...