How To Run /SDF/MON To Collect Snap-Shots
I find this to be very handy when we have a situation where we require troubleshooting in terms of performance as you can see exactly what was running when, how much memory/cpu utilization etc.
To start the collection run transaction /n/SDF/MON or go to SA38 and execute job /SDF/MON.
Click on SCHEDULE NEW MONITORING
Fill in the desired parameters like the duration of the analysis and the interval for the snapshot and execute
Once this is done go back to /SDF/MON and click on EXECUTE
Double click on the line to access the MONITORING DATA page.
On this page you can double click on the DIA/CPU/FREE MEM etc. to get and overview of what was running on the system at that exact time.
Hope this is helpful
Any feedback would be appreciated
Best Regards
Marius
Interesting document , where are snapshots saved?
Hi Johan,
I will check and see where it saves it but you can use the following
/SDF/MON_REORG report (Job SNAPSHOT MONITORING REORG): Reorganization of obsolete /SDF/MON analyses, scheduled daily since ST710 SP1 version.
Johan, they are save in a combination of structure table
/SDF/MON_HEADER
/SDF/WPINFO_EXT_TIME
THLINES
Best Regards
Marius
Hi Marius,
thank you for mentioning the Report for reorganization. Looking at the report you can find the delete statements which perfectly shows all database tables involved:
DELETE FROM /sdf/mon WHERE relid = 'DT' AND guid LIKE lf_pattern.
DELETE FROM /sdf/mon WHERE relid = 'SR' AND guid LIKE lf_pattern.
DELETE FROM /sdf/mon WHERE relid = 'GL' AND guid LIKE lf_pattern.
DELETE FROM /sdf/mon WHERE relid = 'TH' AND guid LIKE lf_pattern.
DELETE FROM /sdf/stad WHERE relid = 'ST' AND guid LIKE lf_pattern.
DELETE FROM /sdf/mon_header WHERE analysis_guid = analysis_guid.
DELETE FROM /sdf/analyses WHERE guid = analysis_guid.
DELETE FROM /sdf/mon_call WHERE guid LIKE lf_pattern.
DELETE FROM /sdf/mon_callpar WHERE relid = '00'
AND guid LIKE lf_pattern.
Kind regards.
Martin