Interested to Buy Any Domain ? << Click Here >> for more details...
how to know if there are expensive sql statements
running?what will you do then to improve the response time?
- 3 Answers
- 12416 Views
- Atos Origin, I also Faced
- E-Mail Answers
Answer Posted / yash
• Detection of Expensive SQL Statements Using the
Transaction Profile and the Statistical Records:
o Using the ST03N transaction profile, you can
identify transactions that cause a significant part of
total response time, as well as transactions with high
database request times. Use of the Transaction Profile:
 Sort the Average DB time (ms) column in descending
order. Transactions with high average DB request times
might be caused by expensive SQL statements.
 Sort the Total Database Time column in ascending
order. Then Total this column. Transactions causing more
than 5% of this total database time are worth a closer look
with respect to tuning measures. .
 Sort the Total Response Time column in ascending
order. Then Total this column. Transactions causing more
than 5% of this total response time are worth a closer look
with respect to tuning measures.
o Use Statistical Records (STAD):
 On the transaction STAD entry screen, enter the
following restrictions:
• Choose a time frame (remember that statistical
records are only available for a certain time).
• Select Task Type D.
• Enter a relevant value for DB request time, for
example, 1000 ms.
 Analyze all available data for long-running dialog
steps by double-clicking individual entries in the result
list.
o Using the Database Monitor:
 On the entry screen of the database monitor you
should check the following values: .
• The quality of the database data buffer should be
higher than 95%. During .warming up. of the SAP system the
quality may be lower, but should still be above 90% (except
during a very early phase).
• Check the number of user calls compared to
recursive calls. There should be less recursive calls than
user calls.
• Check the Reads/User Call. If this value exceeds 30
(blocks read per user call) then this is a strong indicator
for expensive SQL statements.
 Use the Database Process Monitor:
• Enter transaction ST04 and then choose Detailed
Analysis Menu → Oracle Session. .
• Identify the long-running task by finding the
corresponding workprocess ID. Compare the first value in
the Client PID column with the process ID of a work process
in SM50/SM66. Alternately, you can use the link to the work
process information by choosing Process after having marked
one line in the Oracle process overview. .
• Check the current action on the database by
clicking the statement in the SQL statement column. In the
resulting popup window, you will see the following options:
o 1. Dictionary information on the accessed object
o 2. The display of the execution plan for the SQL
statement (also called Explain)
o 3. A reference to the call point in the ABAP
program (if possible) .
• Analyze the Explain
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?
What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?
What is luw (logical unit of work)?
How to apply java stacks ? expalin step by step prcoess
I am installing a sap j2ee engine at crm. When it reaches phase 22 it halts for more than 10 minutes and gives up starting the system. What should I do?
What is password policy?
What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?
What is your organization’s security philosophy? What level of security does your data require? How much risk are you willing to assume in each application area?
How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?
What are patches you applied?
How will u send mail after completion of backup?
What are the Parameters need to be set when connecting EP to r/3 system what are they?
Explain the system trace?
Does any one have SAP basis B1 Resume format for 4 to 5 year experience? if any one have please send me on kishorekharche@gmail.com
what is sox and sod in sap ?
