where will you first see if there is a performance problem....
Answer Posted / manish
Hi,
In Case of performance problem,we need to find out the area
which is causing it.it can be done in following steps:
1.goto tranaction ST03 and checked for avaerage response
time.it sud not be more than 40% of DB response time.
In case it is,select the report/trasnsaction causing that
and look for the user or table bein accessed by double
clicking on that.
2.Check for the top CPU processes in ST06->detailed
analysis,it may happen that some DB related job is
running.clarify frm ur DBA
3.Some background job is running,it can also be checked
from ST03.
4.Data loading is in progress,incase of BW/BI system,in
this case there is no other option than to wait.
5.Check for the no of swaps in st02 and hit ratio.may be
that buffer size is too small to hold the required for huge
data.
6.Network bottleneck can also happen.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How u will give new authorizations?
When should we use Transactional RFC?
What will you do if u got Update failure?
what are the pros and cons of auto extend of table spaces?
How to see when were the optimizer stats last time run?
How to transport objects from Production to Development?
What are the daily transactions?
Explain what is the importance of table t000?
Where XML file is generated in solution manager?
What is an “ok” code is and what is the difference between “t-code” and “ok” code?
Myself Rahul am MBA(Mkt)having 1.5 years marketing experience.and in SAP-SD for 1 years experience.am looking for job.so pl anywher opening then pl let me revert.
Do you have done System copy? What are the steps?
what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?
What is rfc connection?
What is an interface in SAP?