Skip to Content
-1
Feb 28, 2017 at 08:06 AM

Finding out the worst performing programs with ST04

262 Views

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