Question regarding usage of SQLM snapshot

[digantogos]

Need to know the process to follow after creating a snapshot in SQLM for measuring customer code performance in SWLT.

[Armin_Beil · Accepted solution]

Hi Diganto,

snapshots can not be changed at all after they have been created. They are "filled" during creation with a copy of the measurement data that is available in SQLM at that point in time. The process to get a snapshot with the content you are looking for would be: Activate SQLM, execute your program, refresh data within SQLM and then create the snapshot (in transaction SWLT).

But to just display the SQLM measurement results you don't even need a snapshot at all, you can directly check the results in transaction SQLM. SWLT does not measure anything and is a pure display tool that can be used to show SQLM results and CI findings side by side. But when doing this you should keep in mind that not all CI findings of PERFORMANCE_DB are necessarily issue (described here).

Best regards,
Armin

[digantogos · Accepted solution]

Thanks Armin for clarity. The snapshot shows the expected data hits. I do have a question though. Will a single data intensive select query written in an AMDP be faster than open SQL written at the ABAP layer? I am thinking in terms of code push down.

Regards

Diganto