This website is not affiliated with, sponsored by, or approved by SAP AG.

Report to list top dialog execeution times

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

Report to list top dialog execeution times

Postby himubert » Thu Apr 04, 2013 10:30 pm

Hi everyone,

It's been a long time since I last posted a query here. I have a client request to provide a report every week on dialog performance.
Basically, what they need is a list of users who run dialog transactions/programs with execution time equal or more than 1 hour with the following details:
- User ID
- Program name
- Start and end time

It's sort of an SM37 list for dialog transactions instead of background jobs.

Some of these information I believe can be taken from ST03N (ie, total response time of a transaction, total response time of a user) but not in a consolidated format (total response time of all users and transactions). However, I don't think ST03N provides the start and end time for those dialog transactions. Transaction code STAD provides additional information for response time of a transaction with start and end time when double-clicked but the information stored for STAD only lasts up to 2 days.

Would you know any other table/transaction we can use to gather this data from? Thank you so much.

All the best,
Albert
himubert
 
Posts: 17
Joined: Mon Oct 17, 2005 1:55 am
Location: Philippines

Re: Report to list top dialog execeution times

Postby Bebop » Fri Apr 05, 2013 6:58 am

I think you can rather easily write yourself a report for that using the function module SWNC_COLLECTOR_GET_AGGREGATES.

Regards
Frank
Bebop
 
Posts: 79
Joined: Mon Jun 06, 2011 9:13 am

Re: Report to list top dialog execeution times

Postby Zavaros » Sun Apr 07, 2013 2:39 am

Hi,

dialog processes with runtime over 1 hour? Is it a BW system?

btw, ST03 has a top time report. It lists the 40 (or so) longest DIA runs... maybe it helps if there are only few users you should report.

Regards,

Zav
Zavaros
 
Posts: 756
Joined: Thu Oct 24, 2002 10:50 pm
Location: Hungary


Return to Basis

Who is online

Users browsing this forum: No registered users and 5 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.