Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Finding out the worst performing programs with ST04

former_member353844
Explorer

‎02-28-2017 8:06 AM - edited ‎02-03-2024 7:52 PM

0 Kudos

Hi,

We use ST04 to monitor the performance overhead in our production system. We want to prepare a list of the 10 most time consuming programs in the system on a daily basis. Now, when we execute ST04 we get each SQL statements with total DB execution time and the related program name.

But is there any way that we can get a list of programs executed in the last 24 hours along with total DB time consumed by each of them?

Thanks,

Sarif

2 REPLIES 2

raymond_giuseppi
Active Contributor

‎02-28-2017 8:47 AM

0 Kudos

Did you also look at ST03N (or a FM beyond it like SAPWL_STATREC_DIRECT_READ)

Armin_Beil
Product and Topic Expert
Product and Topic Expert

‎03-03-2017 7:43 AM

0 Kudos

SQL Monitor is able to do that. Of course SQLM must have been activated for the time frame you are interested in.

Then you can open transaction SQLM, choose "Display Data" and use the following criteria on the selection screen:

  • By Time Interval: You don't have to use the button "Select Time Series", you can also enter an individual time frame here
  • Aggregation: "By Request"
  • Order by: "Total DB Execution Time"
  • Maximum Number of Records: "10"

In the resulting list check the columns "Request Type" and "Request Entry Point".

Best regards,
Armin