A customer experiences right now a dramatic decline in performance, what will y

A customer experiences right now a dramatic decline in
performance, what will you do?

Question Posted / inder09

4 Answers
8144 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

A customer experiences right now a dramatic decline in performance, what will you do?..

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

A customer experiences right now a dramatic decline in performance, what will you do?..

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

A customer experiences right now a dramatic decline in performance, what will you do?..

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

A customer experiences right now a dramatic decline in performance, what will you do?..

Answer / prvn

Go to ST03->Expert->Total

Check for the average responce time

Is This Answer Correct ?

1 Yes

2 No

Post New Answer

More SAP Basis Interview Questions

What are the Prerequisite for Refresh?? If there are 100 rfc before refresh in Quality Systesm, then after refresh..do we need to create them manually in Quality sys.???

2 Answers ABC,

What is RFC. why will use RFC.

12 Answers HP,

How many times bdls transaction executes for 2 clients

0 Answers CTS,

Is it mandatory to make all the users log off while applying add-ons and s-notes as it is in the case of support packs?

3 Answers

What is central user administration and its uses?

2 Answers

tp –locksys sid=<sid> client=<xxx> is not working. Please me in solving this problem.

3 Answers

Difference between Application server and Central Instance?

2 Answers

Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?

0 Answers Google,

what is the difference b/w UNIX systems logs and Windows sytem logs?

1 Answers

Have you participated in Kernel upgrading and OCS Patches?

1 Answers

Dear Community Members, Could you please help me in solving a urgent problem ? Below is details:- On client side working on SAP GUI print setting in Billing printed copy are problematic...( The problem regarding the improper arrangement of Numerical figures in Excise Invoices )....for your knowledge for easying the problem solution:- 1. from other system when print given the print is ok 2. there is no problem in printer 3. Also reinstalled SAP GUI but of no use As per me, final solution will be re-install the windows ? any other efficient solutions to the problem ?

1 Answers HPL,

How can you find the list of objects that have been repaired in the system?

0 Answers

For more SAP Basis Interview Questions Click Here