Interested to Buy Any Domain ? << Click Here >> for more details...
How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 22626 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / inder09
Using ST03N Choose the Standard Transaction Profile in
transaction ST03N and restrict the display to task type Dialog.
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.
Using the Database Monitor ST04
The quality of the database data buffer should be higher
than 90%.
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
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Transport request types and its syntax?
What is transport layer and domain controller? In which system you have create domain control?
Myself Rahul am MBA(Mkt)having 1.5 years marketing experience.and in SAP-SD for 1 years experience.am looking for job.so pl anywher opening then pl let me revert.
How will you define logon groups ? What is load balancing in sap ?
What is the difference between central instance & application server?
Can any one tell me , what is the role of SAP Security Admin in BW Security and APO Security ?
What is the difference between consolidation and development route ?
the difference between part number and serial number
In the Sap Easy Access Menu I see the menu System -> User Profiles ->Own Data. Other options Hold Data is to keep data values that you have entered in a field of an application for the duration of the session; SET DATA not to overwrite the data and DELETE DATA to delete the set data. Can somebody explain me the Hold Data, Set Data and Delete Data with examples, i mean giving an example of fields?
What is purpose user group in SU01?
How to setup RFC connection in ecc6 tells me steps involved?
How many types of work processes are there in sap ?
please share sap basis admin interview questions .. thanks sadik
What are the different modules of SAP?
How to make security authorization reports?
