AMSUR - Global Performance Analysis: Overview Summarized Log Data
Global Performance Analysis: Overview Summarized Log Data information is stored in SAP table AMSUR.
It is part of development package S_PERF_TRA in software component BC-TWB-TST-P-GPA. This development package consists of objects that can be grouped under "New Performance Trace / Statistics with DB Connection".
It is part of development package S_PERF_TRA in software component BC-TWB-TST-P-GPA. This development package consists of objects that can be grouped under "New Performance Trace / Statistics with DB Connection".
Fields for table AMSUR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| PROCGUID | Log GUID for Performance Analysis | X | PROCGUID | RAW | 16 | |
| DESTIN | Logical destination (specified in function call) | X | RFCDEST | CHAR | 32 | * |
| LFNUM | Global Performance Analysis: Sequence Number | X | LFNUMB | CHAR | 8 | |
| ASCHEMA | Name of Evaluation Schema (Global Performance Analysis) | ASCHEMA | CHAR | 56 | ||
| AOBJECT | Name of Evaluation Object (Global Performance Analysis) | AOBJECT | CHAR | 56 | ||
| .INCLUDE | STRACSUR_D | 0 | ||||
| TOTALEXEC | Total Number of Executions of Identical SQL Statements | TOTALEXEC | DEC | 6 | ||
| EXECTIME | Total Runtime for SQL Statements (in Microseconds) | EXECTIME | DEC | 7 | ||
| RECPROCNUM | Total Number of Database Records Passed to Program | RECPROCNUM | DEC | 6 | ||
| WPROCTIME | Time in Work Process (Reponse Time - Wait Time) in ms | WPROCTIME | DEC | 10 | ||
| KBYTETRANS | Amount of Data Transferred in KB (= Queue + Source + DSQL) | KBYTETRANS | DEC | 7 | ||
| RESPTIME | Response Time in ms | RESPTIME | DEC | 10 | ||
| WAITTIME | Queue Wait Time in ms | WAITTIME1 | DEC | 7 | ||
| CPUTIME | CPU Time in ms | CPUTIME | DEC | 10 | ||
| LDGENTIME | Load and Generation Time in ms | LDGENTIME | DEC | 7 | ||
| MEMORYUSED | Memory Used in MBytes | MEMORYUSED | DEC | 7 | ||
| DBTIME | Database Time in ms | DBTIME | DEC | 7 | ||
| DBCHANGES | Number of Physical Database Changes | DBCHANGES | DEC | 7 | ||
| ROUNDTRIPS | SAP Workload: Number of Roundtrips | ROUNDTRIPS | DEC | 10 | ||
| INOUTDATA | Total Data Volume Between Front End and App. Server (KB) | INOUTDATA | DEC | 9 | ||
| INDATA | Average Data Volume to Application Server per Step (kBytes) | INDATA_P | DEC | 9 | ||
| OUTDATA | Average Data Volume to Front End per Step (kBytes) | OUTDATA_P | DEC | 9 | ||
| TOTALEX_ST | Number of Database Accesses (SEL, UPD, INS, DEL)(Statistics) | TOTALEX_ST | DEC | 7 | ||
| RECPROCNUM_ST | Total Number of DB Recs Delivered to Program (Statistics) | RECPROCNUM_ST | DEC | 7 | ||
| TOTALEXEC_SAW | Standard Deviation: Total Number of Identical SQL Statements | TOTALEXEC_SAW | DEC | 7 | ||
| EXECTIME_SAW | Standard Deviation: Total Execution Time: SQL Statements | EXECTIME_SAW | DEC | 8 | ||
| RECPROCNUM_SAW | Standard Deviation: Total Number of Database Recs Delivered | RECPROCNUM_SAW | DEC | 7 | ||
| WPROCTIME_SAW | Standard Deviation: Time in Work Process | WPROCTIME_SAW | DEC | 10 | ||
| KBYTETRANS_SAW | Standard Deviation: Transferred Data Volume in Kilobytes | KBYTETRANS_SAW | DEC | 7 | ||
| RESPTIME_SAW | Standard Deviation: Response Time | RESPTIME_SAW | DEC | 10 | ||
| WAITTIME_SAW | Standard Deviation: Wait Time in the Queue in ms | WAITTIME_SAW | DEC | 7 | ||
| CPUTIME_SAW | Standard Deviation: CPU Time | CPUTIME_SAW | DEC | 10 | ||
| LDGENTIME_SAW | Standard Deviation: Load and Generation Time in ms | LDGENTIME_SAW | DEC | 7 | ||
| MEMORYUSED_SAW | Standard Deviation: Size of Utilized Memory | MEMORYUSED_SAW | DEC | 7 | ||
| DBTIME_SAW | Standard Deviation: Database Time in ms | DBTIME_SAW | DEC | 7 | ||
| DBCHANGES_SAW | Standard Deviation: Number of Physical Database Changes | DBCHANGES_SAW | DEC | 7 | ||
| ROUNDTRIPS_SAW | Standard Deviation: Number of Roundtrips | ROUNDTRIPS_SAW | DEC | 10 | ||
| INDATA_SAW | Standard Deviation: Data Volume to Application Server | INDATA_SAW | DEC | 9 | ||
| OUTDATA_SAW | Standard Deviation: Data Volume to Front End | OUTDATA_SAW | DEC | 9 | ||
| TOTALEX_ST_SAW | Standard Deviation: Number of DB Accesses (Statistics) | TOTALEX_ST_SAW | DEC | 7 | ||
| RECPROCNUM_STSAW | Standard Deviation: Number of DB Recs Delivered (Statistics) | RECPROCNUM_ST_SAW | DEC | 7 | ||
| STEXTKEY | Metatext | STEXTKEY | CHAR | 4 |