Answer / 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

Answer / venkat

To find expensive sql statement.

Goto DBACOCKPIT ->performance->SQL statement Analysis->shared cursor cache [sap net weaver]
Goto ST04 -> Detailed Analysis Menu -> SQl Request -> Sort by disk reads/ buffer gets / executions.

goto ST05 and find out the sql statements whic consumes more than are around 50000 records are reads.

you have to work with DBA people to finetune them

Answer / rout

U can find expensive SQL statements using T_code:ST05 /SM50
U can solve this either by killing the process or find out
the table that has been accessed adn creat some indexes ,so
that it can be accessed easily or get the workload
statestics information and tune the system.

What is the tablespace? difference between Offline redolog files and online redolog files? Datafiles? Resizing table space how wil do?

1 Answers  

---

how can i integrate ecc6.0sr3 with bi7 or netweaver 7 into single sap system.? pls give me some step. i know installation.

2 Answers   TCS,

---

Hi, I want to import my Transport request from DEV. to Test system (from STMS buffer of DEV.(domain only) but I don’t want Login/PWD screen while importing from DEV to Test System. But I need login/pwd screen while importing TR from Test to PRD system. Presently I have activated all systems as a non trusted systems. If any one has idea please let me know. Thanks in advance! Regards, Raj Chavan.

5 Answers  

---

Screenshot document for solution manager installation.

0 Answers  

---

Difference between DB Verify and DB Check?

1 Answers  

---

HI , Can any one tell me about SM58 transaction code , Why we use this T-Code ?

4 Answers  

---

What is heterogenous system copy and homogenous system copy ?

0 Answers  

---

How to know whether a system is Unicode or non Unicode?

9 Answers  

---

How will you do a local client copy? Just tell us up to the point where you monitor the progress. What if SAP* user is not available at all in your system then how u will do client copy?

2 Answers  

---

Describe your last/current company's landscape, similar to what you would find in STMS>Transport Routes.

0 Answers  

---

What is the database backup strategy?

2 Answers  

---

Transport request types and its syntax?

0 Answers  

---