cancel
Showing results for 
Search instead for 
Did you mean: 

Question regarding usage of SQLM snapshot

digantogos
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

armin_beil_2
Advisor
Advisor
0 Kudos

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
Participant
0 Kudos

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

Answers (1)

Answers (1)

anup_deshmukh4
Active Contributor
0 Kudos

Hello Diganto,

Please find a Link for a quick demo for the SWLT demo

Demo Link

Hope this helps,

Anup D

digantogos
Participant
0 Kudos

Hi Anup

After creating a snapshot in SQLM, the snapshot when called in SWLT says no data found in snapshot.

I created snapshot for just the custom program object. Also even ran it with a time consuming variant. This snapshot had no data even after the custom program run.

I am looking for a step that fills the snapshot with the custom program data hits.