How are expensive SQL select statements recognized?
Answers were Sorted based on User's Feedback
Answer / inder09
High database request time caused by many buffer requests on
the database
High database request time as part of the response time
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / shanker
Use Tcode DBACOCKPIT (ST04) to find SQL statemnts, sort via
the avg elasp time to get expensive SQL statement.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / harsh goel
One way of recognizing them is through aerly watch report.
Is This Answer Correct ? | 0 Yes | 0 No |
How will you define logon groups ? What is load balancing in sap ?
what is diff b/n sm50 and sm66 with explanations and screenshots
1.why we configure the domain controle in production why sap recommended? 2.what is the use of 001 client?
What to do if If Buffer Hit ratio is less than 95%
can we adjust tablespaces from DB02 or we have to it at os level using brtools?
What are the pre requisites to download patches from marketplace ?
How much swap memory should be in the system?
List the types of transport requests?
Which report will give you list of parameters available in sap
if 100 users are accessing perticular table how to know the users who are acessing table.
how can i convert figures into words in sap?pl tell me the function module name?
IF U R BACKGROUNDJOB IS ABORTED..HOW TO RECTIFY?STEP BY STEP