on 12-26-2008 10:32 AM
Hi All,
If I see that a SAP standard transaction is very slow for every user, what are the areas that I will have to look to get it resolved.
All other transactions work quick and only one transaction is very sluggish. How to find the root cause and resolve this?
Thanks
Vijay
Hi Vijay,
Using SQL trace (ST05) you can find the solution.
Please refer to Note 948066 - Performance Analysis.
Regards
Krishna Vanga
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Perform a ST12/ST05 trace on the slow transaction and see if the slowness is coming from ABAP or database side.
Cheers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I have used Tx Code SGEN to reduce the time to open every Transaction. As opening every transaction require the compilation of some programs, reports etc, which takes a lot of time.
This transaction S creen GEN erator, will load(compiled version of ) all the frequently used transactions into the database. Database size will be increased by 2 GB or more.
Refer this link for more details :
http://help.sap.com/saphelp_nw70/helpdata/EN/28/52583c65399965e10000000a114084/frameset.htm
I hope this will help you.
Best Regards,
Pradeep Bishnoi
Edited by: Pradeep Bishnoi on Dec 31, 2008 1:32 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
The transaction may be using a heavy abap application or may be executing expensive SQL statements. Both ST03N and STAD can be used to monitor the response times for your transaction.
More specifically, run transaction ST03N
Check the TRANSACTION PROFILE
Look for the response times for your SLOW transaction
Check where most of the average response time for the transaction is being used up i.e. whether its Database time that is high or CPU time or any other time.This would tell you where the query is being processed for a longer time.
ST05 can be used for a trace in case for expensive SQL if the DB time is higher.
Regards
Chen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vijay
you can check ST03n , STAD and find out what time is more
and take sql trace to find out where is it taking more time .
All the best
Regards
dEE
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
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.