AMSSU - Global Performance Analysis: Trace Summary SQL Statements

Global Performance Analysis: Trace Summary SQL Statements information is stored in SAP table AMSSU.
 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 AMSSU

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
PROCGUIDLog GUID for Performance AnalysisXPROCGUIDRAW16
DESTINLogical destination (specified in function call)XRFCDESTCHAR32*
LFNUMGlobal Performance Analysis: Sequence NumberXLFNUMBCHAR8
.INCLUDESTRACSUM_D0
TABNAMETable NameTABNAMECHAR30*
SQLSTATEMAbbreviated SQL StatementSQLSTATEMCHAR110
TOTALEXECTotal Number of Executions of Identical SQL StatementsTOTALEXECDEC6
IDENTSELPercentage of Identical SQL StatementIDENTSELDEC5
EXECTIMETotal Runtime for SQL Statements (in Microseconds)EXECTIMEDEC7
RECPROCNUMTotal Number of Database Records Passed to ProgramRECPROCNUMDEC6
TIMEPEREXEAverage Execution Time per SQL Statement (in ms)TIMEPEREXECHAR10
RECPEREXEAverage Number of Database Records per SQL StatementRECPEREXECHAR10
AVGTPERRECAverage Processing Time per Database RecordAVGTPERRECCHAR10
MINTPERRECMinimum Processing Time per Database RecordMINTPERRECCHAR10
TABROWLENRecord Length of Specified TableTABROWLENCHAR6
BUFTYPEType of Buffer for Specified TableBUFTYPECHAR5
TABLECLASSTable Category of Specified TableTABLECLASSCHAR8
Privacy Policy