Typical Thread Constellations

There are often caller / calling dependencies between a set of threads.

Example 1: "Complex" column store SQL statement execution

A SQL statement is in the first place executed by a SqlExecutor thread, but this thread may delegate work to JobWorker threads and also JobWorkers may call additional JobWorkers. In this example we can see a hierarchy of four levels. the main SqlExecutor thread 151759 calls the JobWorker thread 111596, this thread calls JobWorker thread 92120 and this thread calls the four JobWorker threads 37304, 111416, 111437 and 111609. Only the four last threads are active at the sample time ("Running") while the other threads are in status "Job Exec Waiting":

Sonia Barwar |

| 04 Jun 2015 10:59 am

Helpful answer

Delta merge ( EXAMPLE) :-

Delta merges are performed by various merge related threads supervised by the MergedogMonitor. In the following case the MergeAttributeThreads are active ("Running") processing columns MANDANT and $trexexternalkey$ of table BALDAT while the other involved processes have to wait for them to finish. When they are finished, the SaveMergedAttributeThread will take over and finish the merge.

10 Tips to Make Million Bucks from SAP as a CareerWell there are a couple of ways through which you can surely make millions in your career in SAP. SAP(Systems, Applications, Products in Data Processing) is a niche area and these days the skill is very much in demand. Thanks to technology now you can certainly be a millionaire in not much time...

Top 10 Emerging and Highest Paid SAP Modules of USA for 2016It comes as no surprise that SAP stands at the number 3 position as per Forbes magazine in terms of the most admired software companies to work for in the United States of America. SAP has been proving time and again that their strategies are extremely state-of-the-art and offer progression to all...

Top 10 Rising SAP Modules for Year 2016By the turn of the year, many things change. Numbers go upward and down letting in new trends to play the game of the day. SAP (Systems, Applications, Products in Data Processing) as an industry is no different in this regard. Google trends show a total revamp in the modules that is going to be...

What are SAP HANA threads and thread samples?
The SAP HANA work, like executing of SQL statements or background tasks is performed by threads. Each SAP HANA process like indexserver or xsengine consist of a set of threads. Thread samples are...