Please follow the below steps to analyses the system health check:
1. Narrow down the problem .. like how many users and what kind of users are facing the problem. Some times some set of users will face performance issue, it may be due to some changes which might have gone into production system recently. Look out for the latest imported transport request.
2. Space monitoring : db02 check space for all table space. Also check for PSAPUNDO
3. SAP Buffer Memory monitoring : ST02 : See the swapping in buffers
4. Look for the logs in SM21 and dump in st22
5. Check the status of your all work processes. Do you have sufficient work processes available. Check if you have proper number of update work processes available, Check the enqueue process, It should be in waiting status most of the time. If everything is fine then check the work process logs. Some times if you are logged into a application server and it may have some connection issue with the database instance. Check it with nipping.
6. CHeck the user distribution via log on groups
7. Check resource quota allocation for RFC group. You should not specify all work process to be used by RFC logon group.
8. Check for jobs which may be using parallel generator option which usually uses many dialog ork processes.
9. Check the alert log for the database. If check point is taking long time then the issue may be with improper configuration of redo log size and groups
10. check sm58 , if you find many trfcs in executying phase then check is there any issue with the destination system.
11. Check basis update statistics jobs.
12. Check in ST04 if you find few sqls which are using more than 5 % of overall database load then you need to tune the SQL. Check if the SQL stmt is using for a proper index.
13. Check which are the main tables which has been used by the users who are facing performance issue. Check there update statistics and indexes storage quality. Also check the fragmentation for tables. If required rebuild index , reorganize tables , update statistics for the tables.
14. Check the IO . If there is bad response time for few disks then contatct to your IO team
There are many more option to improve the system performance.
1. Narrow down the problem .. like how many users and what kind of users are facing the problem. Some times some set of users will face performance issue, it may be due to some changes which might have gone into production system recently. Look out for the latest imported transport request.
2. Space monitoring : db02 check space for all table space. Also check for PSAPUNDO
3. SAP Buffer Memory monitoring : ST02 : See the swapping in buffers
4. Look for the logs in SM21 and dump in st22
5. Check the status of your all work processes. Do you have sufficient work processes available. Check if you have proper number of update work processes available, Check the enqueue process, It should be in waiting status most of the time. If everything is fine then check the work process logs. Some times if you are logged into a application server and it may have some connection issue with the database instance. Check it with nipping.
6. CHeck the user distribution via log on groups
7. Check resource quota allocation for RFC group. You should not specify all work process to be used by RFC logon group.
8. Check for jobs which may be using parallel generator option which usually uses many dialog ork processes.
9. Check the alert log for the database. If check point is taking long time then the issue may be with improper configuration of redo log size and groups
10. check sm58 , if you find many trfcs in executying phase then check is there any issue with the destination system.
11. Check basis update statistics jobs.
12. Check in ST04 if you find few sqls which are using more than 5 % of overall database load then you need to tune the SQL. Check if the SQL stmt is using for a proper index.
13. Check which are the main tables which has been used by the users who are facing performance issue. Check there update statistics and indexes storage quality. Also check the fragmentation for tables. If required rebuild index , reorganize tables , update statistics for the tables.
14. Check the IO . If there is bad response time for few disks then contatct to your IO team
There are many more option to improve the system performance.
No comments:
Post a Comment