how to know if there are expensive sql statements
running?what will you do then to improve the response time?

Answer Posted / lalit rana

You can check your Early watch report which gives the list
of expensive SQL statement.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are saplpd and tcp/ip print server and purpose? And difference b/w saplpd and tcp/ip print server?

2749


A transport is imported into QAS in 2 min. time the same transport when imported into PRD is taking more than 20 min. why? What to do?

1407


Why can't we do it thru some other client?

1620


Which are the most frequent errors encountered while dealing with transports ?

760


Is there a difference between user ddic and sap_all/sap_new?

949






How to apply job on OS Level?

1307


when ever i try to installed sap ecc6.0 sr2 on single system. it show error on phase import abap "Not all objects are successfully processed. DIAGNOSIS: for details see output file with invalid object invalid_objects.txt and log file object_checker.log . SOLUTION: normally it indicate the data load error but in some special cases( for example if some object were created or loaded externally) you can press ok to continue" here error sentence is complete. pls tell what actual error its? is it kernel file related?

2283


What is transport layer and domain controller? In which system you have create domain control?

1394


What are common background jobs that will run in your system?

2119


Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?

649


i'm new for security, pls help if assign the t-code to parent it wll effect to child role or not. can we assign to t-code directly to child role? it wll work or not?

3766


describe how to setup a printer in SAP or where they would look to research why a user/users can not print?

638


What is an interface in SAP?

800


Explain what is “data sets” in sap?

695


A user moved the transport request from dev to qua. How would you trace him?

747