Thursday, 26 May 2016

Performance Checks

Tune Summary (ST02)

Step 1: Go to ST02 to check the Tune summary.

Step 2: If you see any red values, in SWAPS, double –click the same.
 

Step 3: In the below screen click on the tab 'Current Parameters'
 

Step 4: Note down the value and the Profile parameters
 

Step 5: Go to RZ10 (to change the Profile parameter values)

Step 6: Save the changes.

Step 7: Restart the server to take the new changes effect.
 

CPU Utilization (ST06)



Idle CPU utilization rate must be 60-65%,if it exceeds the value then we must start checking at least below things:
  • Run OS level commands – top and check which processes are taking most resources.
  • Go to SM50 or SM66 .Check for any long running jobs or any long update queries being run.
  • Go to SM12 and check lock entries
  • Go to SM13 and check Update active status.
  • Check for the errors in SM21.

ABAP Dumps (ST22)

Here we check for previous day's dumps

Spool Request Monitoring (SP01)

For spool request monitoring, execute SP01 and select as below:
  • Put '*' in the field Created By
  • Click on  execute button.


Here we record only those requests which are terminated with problems.
 

Monitoring Batch Jobs (SM37)


For Monitoring background jobs, execute SM37 and select as below:
  • Put '*' in the field User Name and Job name
  • In Job status, select: Scheduled, Cancelled, Released and Finished requests.

Transactional RFC Administration (SM58)


Transactional RFC (tRFC, also originally known as asynchronous RFC) is an asynchronous communication method which executes the called function module in the RFC server only once.
 

We need to select the display period for which we want to view the tRFCs and then select '*' in the username field to view all the calls which have not be executed correctly or waiting in queue.
 

QRFC Administration (Outbound Queue-SMQ1)

We should specify the client name over here and see if there any outgoing qRFCs in waiting or error state.

QRFC Administration (Inbound Queue-SMQ2)

We should specify the client name over here and see if there any incoming qRFCs in waiting or error state.

Database Administration (DB02)


After you select Current Sizes on the first screen we come to the below screen which shows us the current status of all the tablespaces in the system.

If any of the tablespace is more than 95% and the autoextent is off then we need to add a new datafile so that the database is not full.
We can also determine the history of tablespaces.

We can select Months, Weeks or Days over here to see the changes which takes place in a tablespace.
We can determine the growth of tablespace by analyzing these values.
 


Database Backup logs (DB12)

From this transaction we could determine when the last successful backup of the system was. We can review the previous day's backups and see if everything was fine or not.

We can also review the redo log files and see whether redo log backup was successful or not.
 

2 comments:

  1. My friend Suggest me this blog and I can say this is the best blog to get the best knowledge.Thank you so much for this SAP Basis Training in Chennai blog

    ReplyDelete
  2. Thanks for the great information, was looking for this information from long.Great blogSAP MM Training in Chennai

    ReplyDelete