cancel
Showing results for 
Search instead for 
Did you mean: 

Few Transactions taking longer than others

former_member759680
Contributor
0 Kudos

Hello,

In our SAP Enterprise 4.7 system - VA01, VA02, VA03 and a couple of other Z-transactions are taking more than 3 seconds of Avg dialog response time.

The rest of the transactions are all below 1 second mark.

Could you pleas guide me in troubleshooting this anomaly.

Thanks.

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member759680
Contributor
0 Kudos

apparently, the tables being accessed by these transactions are huge, hence the long time.

Former Member
0 Kudos

also check your db statistics is updated regularly.

Former Member
0 Kudos

SQL Trace is the best option and also check if any User Exists not activated between the business trancsactions code.

Thanks

LK

JPReyes
Active Contributor
0 Kudos

You could run an SQL trace via ST05 to check if theres any expensive statements or if theres any indexes that need tweaking

Regards

Juan