on 06-17-2013 9:28 AM
Dear all,
I have in my production system a transaction that increased in the response time 645%.
I have the average time showing the increase, but I need to know more exactly if the transaction executes normally and only once very long, or it always has a high response time.
In conclusion, I am not interested in the average time, but more to see how the response time exceeded to such a high value.
Is there any possibility to check that ?
Thanks in advance,
Jordan
Absolutely... simple run a trace and you can analize the SQL statements to see where the problem is coming from.
The first thing I usually look into is that the indexes are set corretly, if you can see that the dialog process is taking a lot of time doing sequencial readings from the database this is a strong sign that the indexes are not fit for porpuse.
Regards, Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Perform a runtime analysis of the Tx using the Tx SE30
Additionally you can run ST05 for tracing of the statements.
By this way you can analyse the execution plan.
Check whether the optimizer is picking up the right indexes during the execution.
If there are indexes present and the system is not using the right indexes during the execution of the statement then update the statistics for the tables in the query.
If the problem is with a custom ABAP then you probably need to speak with the developer to optimize the code.
Good Luck
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
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.