checklist basis
TRANSCRIPT
Tasks Critical Tasks
Transaction
Procedure
Ref.
Unit
Check system Availability SM51 - SAP Servers Check work processes Oracle Database Tasks Check daily backups executed and database jobs without errors. Check database jobs The main Database indicators DBA Calendar SAP System Check SMQ1 Check SCOT Check STMS Check STMS STMS Check for old locks. Look any failed updates update cleanup SMQ1/SMQ2- Monitor QRFC SCOT/SOST - E-mail STMS Systems STMS Systems STMS Requests SM12 - Lock entry list. SM13 - Update Records SM13 - Update Records SM50/SM66 - Process Overview
Check that all servers are up Dialog work proc with "running" for long time All work proc with "stopped" for long time Check database backup (last execution).
Status 0 0 Status 100.0 Status Status 95.0 95.0 15.0 Status None None None None None None 0.0 None 1 1 9.0 0 Status 1500
O-W-E Quantity Quantity O-W-E (Gb) O-W-E O-W-E Percent Percent avg O-W-E O-W-E O-W-E Quantity Quantity O-W-E O-W-E Quantity O-W-E Quantity Quantity (GB) Quantity O-W-E mSeconds
DBACOCKPIT - Backup Logs: Overview DBACOCKPIT - Database checks DBACOCKPIT - DB Performance DBACOCKPIT- DB Log File Sync DBACOCKPIT - DBA Calendar
Free space of oraarch Check redo log backup. Check all database messages Verify Data Buffer quality % Verify DD Cache quality % Verify average ms of the day Assure all scheduled tasks finished OK Check for old entries for prior days. Check for old entries for prior days. Import Overview -> Queue Status Overview -> System -> Check ...
Delete requests (Every ...)Check for old entries for prior days. Check for lines with "Err." (previous day until actual time) Cleanup old update entries every Friday (remain last week entries) Load Distribution -> Verify response time > 3000ms Goto - Memory (mem priv) Verify the TemDatabase memory Excessive and unusual dumps Check specific log errors Check Dialog resp time of previous day Check DBtime resp time of previous day Check GUI resp time of previous day Last Minute's Load SAP_APPLICATION_STAT_COLLECTOR SAP_CCMS_CPH_HRCOLL SAP_CCMS_MONI_BATCH_DP SAP_CCMS_PFDB_COUP_SP1 SAP_CHECK_TRFC_ARFC_TABLES SAP_COLLECTOR_FOR_JOBSTATISTIC SAP_COLLECTOR_FOR_NONE_R3_STAT SAP_COLLECTOR_FOR_PERFMONITOR SAP_DELETE_APPLLOG_TABLES SAP_REORG_ABAPDUMPS SAP_REORG_BATCHINPUT SAP_REORG_JOBS SAP_REORG_SPOOL SAP_REORG_NONE_R3_STAT_DB SAP_CHECK_ACTIVE_JOBS SAP_RSRLDREL3 JOBS Canceled/Finished/Ready/Released (Check of Canc./Releas./Ready jobs from previ Very long jobs running
Check logon information SMLG - Logon Groups Memory Problem Check for spool problems. Review and resolve dumps. System log SM04 SP12 - Memory allocation ST22 - ABAP Dump Analysis SM21 - System log ST03 (expert mode) - TOTAL resp time Collector of workload statistics. ST03 (expert mode) - TOTAL resp time ST03 (expert mode) - TOTAL resp time ST03 (expert mode) - TOTAL resp time SAP System Jobs Review jobs SAP Note 16083 SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis SM37 - Job Analysis Database and Application Servers Review buffer statistics. Review buffer statistics. Operating system Performance ST02 - Tune Summary ST02 - Tune Summary ST06N - OS Monitor
40% of mSeconds resp. Time 200 1500 Status Status Status Status Status Status Status Status Status Status Status Status Status Status Status Status Status 0 mSeconds mSeconds O-W-E O-W-E O-W-E O-W-E O-W-E O-W-E O-W-E O-W-E O-W-E O-W-E O-W-E O-W-E O-W-E O-W-E O-W-E O-W-E Quantity Quantity
Look for hitratio quality buffers lower 95% Look for hitratio Exp/Imp buffers lower 80% CPU idle (previous day) Pages out (previous day)
95 80 25 0
Quantity Quantity Percent Quantity
1-dez
2-dez
3-dez
4-dez
5-dez
6-dez
7-dez
8-dez
9-dez
10-dez
11-dez
12-dez
13-dez
14-dez
15-dez
16-dez
17-dez
18-dez
19-dez
20-dez
21-dez
22-dez
23-dez
24-dez
25-dez
26-dez
27-dez
28-dez
29-dez
30-dez
31-dez