/SDF/SQLHIST - SQL Monitor: Delta records for top SQL statements
SQL Monitor: Delta records for top SQL statements information is stored in SAP table /SDF/SQLHIST.
It is part of development package /SDF/ZQLM in software component SV-SMG-DIA. This development package consists of objects that can be grouped under "Package for SQL Monitor".
It is part of development package /SDF/ZQLM in software component SV-SMG-DIA. This development package consists of objects that can be grouped under "Package for SQL Monitor".
Fields for table /SDF/SQLHIST
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TIMESTAMP | Timestamp for SQLM Data Collection | X | /SDF/SQLTIMESTAMP | DEC | 8 | |
| .INCLUDE | KEY | X | /SDF/ZQLMKEY | 0 | ||
| PROGNAME | ABAP Program Name | X | PROGNAME | CHAR | 40 | |
| PROGKIND | SQL Monitor: Program Kind | X | /SDF/ZQLMPROGKIND | CHAR | 1 | |
| PROCTYPE | SQL Monitor: Processing Block Type | X | /SDF/ZQLMPROCTYPE | CHAR | 4 | |
| PROCNAME | SQL Monitor: Processing Block Name | X | /SDF/ZQLMPROCNAME | CHAR | 93 | |
| PROCLINE | SQL Monitor: Line Number in Processing Block | X | /SDF/ZQLMPROCLINE | INT4 | 4 | |
| .INCLUDE | SUBKEY | X | /SDF/ZQLMSUBKEYINT | 0 | ||
| RUNLEVEL | SQL Monitor: Run Mode | X | /SDF/ZQLMRUNLEVEL | CHAR | 1 | |
| ROOTTYPE | SQL Monitor: Request Type | X | /SDF/ZQLMROOTTYPE | CHAR | 1 | |
| ROOTNAME | SQL Monitor: Request Entry Point (Transaction, etc.) | X | /SDF/ZQLMROOTNAME | CHAR | 60 | |
| STMTKIND | SQL Monitor: SQL Operation | X | /SDF/ZQLMSTMTKIND | CHAR | 1 | |
| TABLENAME | SQL Monitor: Table Name | X | /SDF/ZQLMTABLENAME | CHAR | 16 | |
| HASH | Hash Value (160 Bits) | X | HASH160X | RAW | 20 | |
| .INCLUDE | SOURCEINFO | /SDF/ZQLMSOURCEINFO | 0 | |||
| INCLUDE | ABAP Program Name | PROGNAME | CHAR | 40 | ||
| LINE | 4 Byte Signed Integer | INT4 | INT4 | 4 | ||
| PGMID | Program ID in Requests and Tasks | PGMID | CHAR | 4 | ||
| OBJECT | Object Type | TROBJTYPE | CHAR | 4 | ||
| OBJ_NAME | Object Name in Object Directory | SOBJ_NAME | CHAR | 40 | ||
| DEVCLASS | Package | DEVCLASS | CHAR | 30 | * | |
| .INCLUDE | PAYLOAD | /SDF/SQLMPAYLOAD | 0 | |||
| XCNT | SQL Monitor: Total Number of Executions | /SDF/SQLMEXECNT | DEC | 16 | ||
| RCNT | SQL Monitor: Internal Sessions Affected | /SDF/SQLMROLLAREACNT | DEC | 16 | ||
| XCNTRCNT | SQL Monitor: Executions per Internal Sessions | /SDF/ZQLMEXECNTROLLAREACNT | DEC | 16 | ||
| RTMIN | SQL Monitor: Minimum Value of Execution Time | /SDF/ZQLMRUNTIMEMIN | DEC | 16 | ||
| RTMAX | SQL Monitor: Maximum Value of Execution Time | /SDF/ZQLMRUNTIMEMAX | DEC | 16 | ||
| RTCNT | SQL Monitor: Count | /SDF/SQLMRUNTIMECNT | DEC | 16 | ||
| RTSUM | SQL Monitor: Total Execution Time | /SDF/ZQLMRUNTIMESUM | DEC | 16 | ||
| RTSQS | SQL Monitor: Runtime Sum of Squares | /SDF/ZQLMRUNTIMESQS | DEC | 16 | ||
| RTAVG | SQL Monitor: Mean Value of Execution Time | /SDF/ZQLMRUNTIMEAVG | DEC | 16 | ||
| RTDEV | SQL Monitor: Standard Deviation of Execution Time | /SDF/ZQLMRUNTIMEDEV | DEC | 16 | ||
| DBMIN | SQL Monitor: Minimum Value of Fetched / Modified Records | /SDF/ZQLMDBCOUNTMIN | INT4 | 4 | ||
| DBMAX | SQL Monitor: Maximum Value of Fetched / Modified Records | /SDF/ZQLMDBCOUNTMAX | INT4 | 4 | ||
| DBCNT | SQL Monitor: DB Count Count | /SDF/SQLMDBCOUNTCNT | DEC | 16 | ||
| DBSUM | SQL Monitor: Total Fetched or Modified Records | /SDF/ZQLMDBCOUNTSUM | DEC | 16 | ||
| DBSQS | SQL Monitor: DB Count Sum of Squares | /SDF/ZQLMDBCOUNTSQS | DEC | 16 | ||
| DBAVG | SQL Monitor: Mean Value of Fetched / Modified Records | /SDF/ZQLMDBCOUNTAVG | DEC | 16 | ||
| DBDEV | SQL Monitor: Standard Deviation of Fetched / Modif. Records | /SDF/ZQLMDBCOUNTDEV | DEC | 16 | ||
| DDATE | Last RTM Collection Datum | DATS | 8 | |||
| DTIME | Last RTM Collection Time | TIMS | 6 |