Friday, 15 July 2011

Guidelines for activating a Performance trace

This article answers the following queries :

What are the guidelines to be followed for activating a performance trace ?
 Guidelines for activating a Performance trace
  1. If you are tracing a particular activity of a user, please make sure that the particular user is not performing any other activity in the system. Otherwise trace file will be difficult to analyze. For reasons of simplicity, please request user to perform only one activity while the trace is activated.
  1. Please make sure that no background jobs or update processes are running in that SAP for  that particular user whose activity is being traced. Otherwise trace won’t be clear

  1. By default, SQL trace is selected in ST05 transaction. Incase you would like to trace others( like RFC trace, buffer trace)  please activate them also.

  1. Normally we are interested in the buffer load processes that get recorded while tracing an activity through SQL trace. Therefore, it is suggested to execute the program or activity that is to be traced once before actually tracing it so that all the buffer loads processes will happen. In the next run, since buffers were already loaded SQL trace doesn’t capture un-necessary details related to buffer load which makes it easy to analyze the trace.

  1. In cases of distributed SAP system, where there are number of application servers  then you need to activate the trace in the particular application server where the user is performing the activity. In other words, trace won’t get recorded if you activate trace in one application server and user is performing the activity in another application server.

  1. If you would like to record a trace for background job or for an update request in a distributed SAP system, it is suggested to activate the trace in all the application servers that are present in the SAP system. This is required because you will never know to which application server the particular request goes for execution.

If you are tracing an activity of any other user you can look at following monitors during the trace :

  • Workprocesses overview (SM50/SM66)
  • Operating system monitor of Database server to identity any CPU bottlenecks in database server)
  • Database process monitor for monitoring the execution of SQL statements

Profile parameter settings for Performance Trace (ST05):

Please note that trace cannot be taken for very long duration as the size of the trace file is limited as set by SAP profile parameter. When the trace file is full, the oldest entries are deleted or overwritten by the newest entries i.e. writing to the trace file is cyclical.

The SAP profile parameter rstr/max_diskspace is used to set the size of the trace file in a SAP system. The default trace file size is 16MB

For a trace file, default file name also can be set using the SAP profile parameter rstr/file.

Enter your email address:

Delivered by FeedBurner

Wednesday, 13 July 2011

SAP Netweaver Interview questions with answers - set 4

This article provides the 10 most important SAP Basis interview questions covering SAP, Database and operating system areas. 

Have updated answers for some of the questions. For rest will update as soon as I write relevant article on the same.


1.  A user complaints to you that a background usually takes 3hrs to run but it is already 6hrs completed and still the job is running. How to analyse the issue ?

Answer :  Troubleshooting longrunning jobs 
                  Identifying long running jobs

2. Do you have experience in handling SCM system? If yes, how to you start or stop livecache in SCM or APO(Advanced Planning and optimiser) system ?

Answer:  Yes, I do have experience in handling SCM system. Livecache can be started or stopped using LC10 transaction code.

Related Link :    How to start or stop livecache in SCM or APO system?

3. If a java stack is down ? How do you troubleshoot ?

Answer:  Will update later

4. If in a java only system, administrator user id got locked, how do you resolve this issue ?


5. How to create a server node in Java based SAP system ?

Answer: Will update later

6. In system refresh activity, database restoration is done and sap system is up. Now, what are the poststeps system refresh steps that you perform ?

Answer: Will update later
7. How do you analyze an expensive SQL statement ? 

Answer : Please go through below related links

8. What do you know about Wily introscope agent ? What is the use of wily introscope ? What is the version of wily introscope that you have implemented ?

Answer: Wily introscope is a java monitoring agent that is  installed in a high available system like Solution manager and all other satellite systems that are to be monitored are connected or configured. So, using wily introscope end to end root cause analysis can be done. In cases of performance issue of java systems, troubleshooting can be better done using wily introscope as it provides so many details related to memory consumption, CPU usage, system availability, paging, Garbaga collection details etc.

Wily introscope is available in different versions like  7.1 ,  8.0 and latest one 9.1

9. What is the transaction to perform support pack upgrade in ABAP stack ?

Answer:  SPAM is the transaction code used to perform support pack upgrade in ABAP stack.

10. Your SAP systems are based on which operating system ? What is the version of operating system do you use? 

Answer: For example, You can reply based on the operating system you are using like AIX operating system with version 5.3

Enter your email address:

Delivered by FeedBurner