ST12 vs sqltrace response time.

lucjan_chmura — Tue, 09 Jan 2024 20:28:27 GMT

Dear Colleagues,

I've got a customer migrating from a competitor database to HANA (2.00.071). One of their jobs is taking ~30% longer on HANA. During tracing, I see a significant difference in duration for the statements involved.

ST12 trace shows an average duration per execution twice as much as the numbers I see (duravg ) on HANA with sqltrace. (e.g. +400 microsecs vs 190 microsecs on HANA etc..)

How can this be explained, and what would you recommend the next step debugging this?

Cheers,

Lucjan

Re: ST12 vs sqltrace response time.

HermannGahm — Tue, 08 Apr 2025 19:11:33 GMT

Hi,

ST12 (like SAT) measures in the ABAP VM while ST05 measures on database interface level (closer to the DB) and HANA traces measure directly on the DB.

So ST12 / SAT measurements contain more executed code in the stack than ST05 traces and HANA traces even less executed code and no network communication if measured directly on the DB server.

Probably not helpful anymore after 1 year... 😉

Kind regards,

Hermann

Question Re: ST12 vs sqltrace response time. in Technology Q&A

ST12 vs sqltrace response time.

Re: ST12 vs sqltrace response time.