1st Basis Logo 1025 S. Moorland Road, Suite 300
Brookfield, WI 53005
Office: (414) 326-3194

1st Watch™ SAP Monitoring Report
Report For:  customer Date:  report_date Technician:  technician
Report No:  reportno Date Range:  report_date_range
System Availability and Recovery:

SAP® best practice recommends the following Critical Tasks checks be performed daily. We have moved Availability (SM51) and Backups (DB12) to the top of the list as they are the most critical to daily operations and disaster recovery.

PRD - SM51 SAP Active Server List GOOD
Server NameHost nameStatus
PR1CI_PR1_00 pr1ci Active
Active Services:  Dialog Batch Update Upd2 Spool Enqueue ICM
sapps102_PR1_02 sapps102 Active
Active Services:  Dialog Update Upd2 Spool ICM
sapps103_PR1_03 sapps103 Active
Active Services:  Dialog Update Upd2 Spool ICM
sapps104_PR1_04 sapps104 Active
Active Services:  Dialog Update Upd2 Spool ICM
sapps105_PR1_05 sapps105 Active
Active Services:  Dialog Update Upd2 Spool ICM
sapps106_PR1_06 sapps106 Active
Active Services:  Dialog Update Upd2 Spool ATP ICM
sapps107_PR1_07 sapps107 Active
Active Services:  Dialog Update Upd2 Spool ICM
Comments:  Application Server sapps107_PR1_07 was added last week

PRD - DB12 Backup / Restore Information ERROR
Backup TypeLast BackupBackup Status
Full DB Backup 2015-01-15 - 00:00:00 Good
Differential DB Backup 2015-01-15 - 00:00:00 Good
Transaction Log Backup 2015-01-15 - 00:00:00 Error
Full Master Backup 2015-01-15 - 00:00:00 Good
Full MSDB Backup 2015-01-15 - 00:00:00 Error
Error Log:  Error: The backup was stopped because you have reached a disk quota limit on the server.


Critical System Errors:

PRD - SM37 Cancelled Background Jobs ERROR
Job NameUsernameStartEndCount
Z_PROCESS_ORDER_PRE20151 NSMITH 10/29/2015 09:46:38 10/30/2015 09:49:56 17
Step 001 started (program PPARCHP1, variant PPO_PREPROC, user ID NSMITH)
Internal session terminated with runtime error SYSTEM_CANCELED
Z_DAILY_EDI_OUTPUT BFEHL 10/29/2015 09:46:38 10/30/2015 09:49:56 170
No log entries are available for the selected job
No ABAP error found
ZSDR_PO_INVOICE_ITEMS DBEISWENGER 10/29/2015 09:46:38 10/30/2015 09:49:56 1
No log entries are available for the selected job
No ABAP error found
Comments:  Large number of EDI jobs canceled. Check SM58 for RFC transmit issues

PRD - SM21 SAP System Log (Critical Errors) ERROR
DateTimeUserTCodeAppSrvrErr Typ/Cnt
10/30/2015 00:00:00 SAPSYS SM21 sapapp1 ERR TYP
Database error: TemSe->XRTAB(0)->1 for table TST01 key 7
10/30/2015 00:00:00 RFUSER SM21 sapapp1 ERR TYP
Operating system call recv failed (error no. 10054) 55
10/30/2015 00:00:00 JSMITH SM21 sapapp1 ERR TYP
Runtime error "DBIF_RSQL_SQL_ERROR" occurred. 205
10/30/2015 00:00:00 JJONES SM21 sapapp1 ERR TYP
Database error 121 at SEL access to table KNKK 5
Comments:  See ST22 for error: DBIF_RSQL_SQL_ERROR

PRD - ST22 ABAP Runtime Errors (Dumps) ERROR
App ServerLast DateLast TimeClnt UserErrorCount
sapps103 10/30/2015 10:12:45 400 NSMITH TABLE_INVALID_INDEX 9
Error in ABAP/4 statement when processing an internal table.
sapps103 10/30/2015 00:09:26 000 RFUSER20 SYSTEM_CORE_DUMPED 2
Error in ABAP/4 statement when processing an internal table.
sapps102 10/30/2015 14:22:34 400 RFUSER11 RAISE_EXCEPTION 52
Error in ABAP/4 statement when processing an internal table.
sapps102 10/30/2015 09:10:03 400 FBRIGHT MOVE_TO_LIT_NOTALLOWED 64
Error in ABAP/4 statement when processing an internal table.
sapps104 10/30/2015 08:49:27 400 FBRIGHT MESSAGE_TYPE_X 8
Error in ABAP/4 statement when processing an internal table.
sapps104 10/30/2015 00:00:06 400 RFUSER20 LIST_TOO_MANY_LPROS 50
Error in ABAP/4 statement when processing an internal table.
sapps104 10/30/2015 20:48:27 400 RFUSER02 ITAB_ILLEGAL_SORT_ORDER 212
Error in ABAP/4 statement when processing an internal table.
sapps107 10/30/2015 00:04:53 000 SAPSYS DBIF_RSQL_SQL_ERROR 1
Error in ABAP/4 statement when processing an internal table.
sapps102 10/30/2015 17:45:16 400 JJONES DBIF_RSQL_INVALID_RSQL 120
Error in ABAP/4 statement when processing an internal table.
Comments:  ITAB_ILLEGAL_SORT_ORDER is most frequent error


Database Locks and Updates:

PRD - SM12 Table Lock Entries WARN
ClientUserDateTimeTable
400 JJONES 10/30/2015 00:00:00 EBAN
Comments:  This lock is now 4 days old

PRD - SM13 Database Update Requests (Failures) ERROR
ClientUserDateTimeTCodeStatus Count
400 RFUSER10 10/22/2015 21:54:46 COR6N Error in V2 Part 7
400 RFUSER10 10/13/2015 21:25:03 ZM46B Error in V2 Part 1
400 NSMITH 10/10/2015 13:49:09 VT02N Error 17
400 JBEISW 10/07/2015 10:40:27 LI02N Error (no retry) 3
400 RFUSER07 09/27/2015 21:25:59 COR6N Error (no retry) 4
400 RFUSER23 09/23/2015 00:06:09 ZM46B Error in V2 Part 1
400 RFUSER11 09/22/2015 21:30:39 COR6N Error (no retry) 1
400 RFUSER03 09/19/2015 21:25:18 ZB2B Error in V2 Part 7
400 RFUSER10 09/08/2015 21:23:50 COR6N Error in V2 Part 5
400 BFEHL 09/03/2015 21:23:12 VL02N Error 2
Comments:  V2 errors cannot be updated


Tunning and Performance:

PRD - ST02 Tune Summary (server-specific) WARN
Buffer HitRatio % Alloc. KB Freesp. KB % Free Sp. Dir. Size FreeDirEnt % Free Dir Swaps DB Accs
Nametab (NTAB) 0
Table definitions 99.34 58,872 4 5 6 7 8 9 10
Field definitions 99.26 3 4 5 6 7 8 9 10
Short NTAB 99.99 3 4 5 6 7 8 9 10
Initial records 91.90 3 4 5 6 7 8 9 10
                0  
programs 99.26 3 4 5 6 7 8 274.306 10
CUA 99.77 3 4 5 6 7 8 9 10
Screen 99.90 3 4 5 6 7 8 9 10
Calendar 100.00 3 4 5 6 7 8 9 10
OTR 73.91 3 4 5 6 7 8 9 10
                0  
Tables   0
Generic Key 99.87 3 4 5 6 7 8 9 10
Single record 99.79 3 4 5 6 7 8 9 10
                   
Export/import 42.54 3 4 5 6 7 8 9 10
Exp./ Imp. SEM 99.91 3 4 5 6 7 8 9 10

SAP Memory Curr.Use % Curr.Use [KB] MaxUse [KB] In Mem [KB] OnDisk [KB] SAPCurCache HitRatio %
Roll area 0.78 3 4 5 6 7 8
Page area 4.42 3 4 5 6 7 8
Extended memory 35.26 3 4 5 6 7 8
Heap memory   3 4 5 6 7 8

Call Stati HitRatio % ABAP/4 Req ABAP fails DBTotCalls AVTime [ms] DBRowsAff.
Select single 98.81 3 4 5 6 7
Select 89.02 3 4 5 6 7
Insert 0.00 3 4 5 6 7
Update 0.00 3 4 5 6 7
Delete 0.00 3 4 5 6 7
Total 93.91 3 4 5 6 7
Comments:  While the swaps seem high, they are within expected parameter ranges

PRD - ST03 Dialog Times GOOD
Server Name# StepsAvg. Proc. TimeAvg. CPU TimeAvg. DB Time Avg Dialog Time (ms)
sapps101_PR1_01 32,562 550.1
sapps102_PR1_02 45 1,250.0
sapps103_PR1_03 21,065 762.4
sapps104_PR1_04 1,542 588.0
Comments:  Average dialog times above 1000 ms are considered slow and, if persistent, can signal a performance bottleneck

PRD - ST04 SQL Server Performance Analysis: Overview GOOD
Memory
Phys. Memory (MB) Hit Ratio
Current Memory (MB) Data Cache (MB)  %
SQL Memory Setting Proc. Cache (MB)  %
Windows Memory Option Lock Cache (MB)
Free Pages (MB)
Comments:  Hit Ratios are good

Database Disk Space
Total Data Size (MB) Total Log Size (MB)
Data Free Space (MB) Log Free Space (MB)
Comments:  Database space is good


PRD - ST06 Operating System Monitor (Windows 2008) GOOD
Drive NameSize (MB) Free (MB)Free (%)
C: 71,576 56,228 79
D: 51,169 3,105 6
E: 30,716 13,364 44
M: 409,596 323,299 79
Comments:  Drive D: is a swap page drive so drive space is static.

PRD - SP01 Output Controller (Spool Request Errors) ERROR
Spool #UserDateTimeTitleCount
41730 NSMITH 10/30/2015 00:00 SMART ICZ4 NSMITH 4
41716 BFEHL 10/30/2015 00:00 SMART ZMP BFEHL 52
41689 DBEISWENGER 10/30/2015 00:00 LVS1 OUTM DBEISWENGER 17
41652 DPASTRICH 10/30/2015 00:00 SMART ZPP DPASTRICH 300
41651 RFUSER 10/30/2015 00:00 SMART SHK1 RFUSER 1
41647 RFUSER13 10/30/2015 00:00 SMART SHK1 RFUSER13 2
40349 SAPSYS 10/30/2015 00:00 LIST1S COS2 AQZZZSALEFLO 2
Error Log:
SAP spool error log
=====================
Print request processing log
The host spool is reporting errors
Windows/NT error 1801 [\\PRTSRV\HP4350]: "The printer name is invalid."
Errors occurred processing this print request
Error during print request output. l_rc = 1
There may be no printout

PRD - SM35 Batch Input (Session Overview) ERROR
Session NameStatusCreated byDate TimeProgramError Count
INIT.LOAD Error SAPSYS 11/19/2015 09:00:03 ZSD_TRASF_SPARE_PARTS_MODULA 6
INV_NEG Error SAPSYS 11/03/2015 09:20:04 ZSD_MODULA_INV_DIFF_MODULA_SAP 1
MISSION Error SAPSYS 10/30/2015 11:30:06 ZSD_MISSION_FROM_MODULA_TO_SAP 1
MRP Error HIREFBC 10/29/2015 19:30:00 /SAPDMC/SAP_LSMW_BI_RECORDING 614
Comments:  /SAPDMC/SAP_LSMW_BI_RECORDING has over 600 errors. This is a persistent error