Answer / inder09

By combining the functions of SM50/SM66 and ST04 you are
able to answer

You can find what report is accessing what table. Also you
can identify the user who started this report.

You find what select statement accesses what table, and you
can get an "Explain" for it

Using ST04 you can identify what kind of table access is
used to retrieve data from the database

Answer / srikanth

Check the logon groups to see if there ia a heavy load on
any particular server. If it is, then have the users to
logoff and login again using someother instance. Check for
sm12 locks. See if there are some exclusive locks on any
particular table. sometimes it may happen that a particular
table may be accessed by some user and others are trying to
access it and waiting for it.

Answer / nani

To analyze the performance in SAP system we use below
transactions:

Application level:

ST03,ST02,SM50,SM21

Database Level:

DB02,DB13(Update table statistics),ST04,ST05

OS Level:

ST06

Answer / prvn

Go to ST03->Expert->Total

Check for the average responce time

How to login in to SAP from command level?

2 Answers  

---

how java instance processes starts?or how java startup and control frame work starts the java instance?

1 Answers   TCS,

---

Table space creation

2 Answers  

---

Can SAP patches be installed when other users are online?

8 Answers   TCS,

---

What types of files are created during the export?

6 Answers  

---

---

What are the transport routes?

2 Answers  

---

What is Extractor?

2 Answers   SAP Labs,

---

how to increase table space in brtools?

5 Answers  

---

How to Upload and Downloading of roles?

2 Answers   IBM,

---

What is the minimum work processes needed for a SAP server?

13 Answers   IBM,

---

If a background job runs more than the time it should be completed normally then what actions will u take?

0 Answers  

---

there are 500 users logged into the sap system, the system goes down and one cannot login using sapgui. Whyen check the workprocess from dpmon the dialog workprocesses are free. what action does one take as basis consultant

12 Answers   IBM,

---