on 2009 Jun 11 2:00 PM
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.
apparently, the tables being accessed by these transactions are huge, hence the long time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
also check your db statistics is updated regularly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SQL Trace is the best option and also check if any User Exists not activated between the business trancsactions code.
Thanks
LK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.