Transactions code running very slow why it happened could you please let me know
Why Transactions code running very slow.
Updated May 18, 2018
Comments
Recommended Posts:
- SAP BASIS Full Form & Meaning
- SAP BASIS Training Tutorials for Beginners
- How to Check SAP Version
- Lock/Unlock SAP T-Codes via SM01
- Reset SAP* Password
- What is SAP Router
- SAP Work Process
- SAP Compatible Printers
- Check SAP Services in Linux and Unix
- SAP Schedule Background Job
- Stop Scheduled Background Job
- SAP Spool Overflow
- SAP Basis DB Refresh Steps
- Difference between DDIC and SAP
- SAP Basis Backup Type
- SAP Basis Tcodes
- SAP BASIS Scope and Opportunity
- SAP BASIS Certification Cost in India
- SAP BASIS Interview Questions
- SAP Security Interview Questions
×
Ask the users for the following information:
· Has the transaction always been slow, or has it only just started to slow down?
· Is the problem in a new program or transaction?
· Is the slowdown only during peak periods or is it fairly constant?
· Have there been recent changes in workload?
· Is just this one transaction slow or are other transactions or applications also now performing poorly?
Attempt to localize the performance bottleneck using the information you obtained.
If you feel this issue may be isolated to one particular transaction, program or application, you may also need assistance from the application developers. These developers understand the process flow of the application, and can help you to change and test statements in the program.
Use the following analysis options:
· Have the system display the transactions (Transactions).
· Find out whether any exclusive wait situations exist (Wait Situations (Exclusive)).
· Check for missing indices in the tables used by the transaction (Index Analysis).
· Check the cache hit rates or speed of table searches. To do this, analyze the bottlenecks, for example.
· Use the command monitor to perform runtime analyses of any long–running SQL statements.