A customer experiences right now a dramatic decline in
performance, what will you do?
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 6 Yes | 1 No |
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.
Is This Answer Correct ? | 2 Yes | 0 No |
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
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prvn
Go to ST03->Expert->Total
Check for the average responce time
Is This Answer Correct ? | 1 Yes | 2 No |
why TMSADM user is used for? and can I change the password of the same if yes how to do that? If not why shouldnt we?
How you will do client copy?
as a basis consultant,what all tasks you've done on unix?
what is the definitions of Roll In Time,roll Area, Roll Out Time And Wait Time,Please reply needful
What are the key activities that you perform as part of sap basis support?
A customer experiences right now a dramatic decline in performance, what will you do?
What is osp$ mean?
Where the patches are installed (CI or DI or both)?
Incase my sap system was down (users are unable to login to sap system) how to analyze this problem?
What is TMS, TDC, CTS, STMS and difference among them?
I am having develoment with 3 clients (100,200,300) and in PRD one client(500)after an year i purchased a new machine for quality so i want to import 2 clients (100,200) and in qas but i want the 100 client only sap_user and sap_cust profiles and 200 client sap_all only can i do that in quality any answers plz suggest me
2 Answers IBM, Yash Technologies,
Where can I get a list of all transaction codes in SAP?