SQLMSHCD - SQL Monitor: Data / Request
SQL Monitor: Data / Request information is stored in SAP table SQLMSHCD.
It is part of development package SQLM_CORE in software component BC-DWB-TOO-RTA. This development package consists of objects that can be grouped under "SQL Monitor Core".
It is part of development package SQLM_CORE in software component BC-DWB-TOO-RTA. This development package consists of objects that can be grouped under "SQL Monitor Core".
Fields for table SQLMSHCD
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOTID | SQL Monitor: Snapshot ID | X | SQLMSNAPSHOTID | RAW | 16 | |
| .INCLUDE | KEY | X | SQLMHCKEY | 0 | ||
| PROGNAME | ABAP Program Name | X | PROGNAME | CHAR | 80 | |
| PROGKIND | SQL Monitor: Program Kind | X | SQLMPROGKIND | CHAR | 2 | |
| PROCTYPE | SQL Monitor: Processing Block Type | X | SQLMPROCTYPE | CHAR | 8 | |
| PROCNAME | SQL Monitor: Processing Block Name | X | SQLMPROCNAME | CHAR | 186 | |
| PROCLINE | SQL Monitor: Line Number in Processing Block | X | SQLMPROCLINE | INT4 | 4 | |
| HASHCODE | SQL Monitor: Source Hash Code | X | SQLMHASHCODE | RAW | 8 | |
| .INCLUDE | SUBKEY | X | SQLMSUBKEYINT | 0 | ||
| RUNLEVEL | SQL Monitor: Run Mode | X | SQLMRUNLEVEL | CHAR | 2 | |
| ROOTTYPE | SQL Monitor: Request Type | X | SQLMROOTTYPE | CHAR | 2 | |
| ROOTNAME | SQL Monitor: Request Entry Point (Transaction, etc.) | X | SQLMROOTNAME | CHAR | 120 | |
| STMTKIND | SQL Monitor: SQL Operation | X | SQLMSTMTKIND | CHAR | 2 | |
| TABLENAME | SQL Monitor: Table Name | X | SQLMTABLENAME | CHAR | 32 | |
| .INCLUDE | PAYLOAD | SQLMPAYLOAD | 0 | |||
| XCNT | SQL Monitor: Total Number of Executions | SQLMEXECNT | INT4 | 4 | ||
| .INCLUDE | ROLLAREA | SQLMROLLAREA | 0 | |||
| RCNT | SQL Monitor: Internal Sessions Affected | SQLMROLLAREACNT | INT4 | 4 | ||
| XCNTRCNT | SQL Monitor: Executions per Internal Sessions | SQLMEXECNTROLLAREACNT | DEC | 16 | ||
| .INCLUDE | RUNTIME | SQLMRUNTIME | 0 | |||
| RTMIN | SQL Monitor: Minimum Value of SQL Execution Time | SQLMRUNTIMEMIN | DEC | 16 | ||
| RTMAX | SQL Monitor: Maximum Value of Database Execution Time | SQLMRUNTIMEMAX | DEC | 16 | ||
| RTCNT | SQL Monitor: Count | SQLMRUNTIMECNT | INT4 | 4 | ||
| RTSUM | SQL Monitor: Summarized Database Execution Time [ms] | SQLMRUNTIMESUM | DEC | 16 | ||
| RTSQS | SQL Monitor: Runtime Sum of Squares | SQLMRUNTIMESQS | DEC | 16 | ||
| RTAVG | SQL Monitor: Mean Value of DB Execution Time | SQLMRUNTIMEAVG | DEC | 16 | ||
| RTDEV | SQL Monitor: Standard Deviation of Database Execution Time | SQLMRUNTIMEDEV | DEC | 16 | ||
| .INCLUDE | DBCOUNT | SQLMDBCOUNT | 0 | |||
| DBMIN | SQL Monitor: Minimum Value of Processed Records | SQLMDBCOUNTMIN | INT4 | 4 | ||
| DBMAX | SQL Monitor: Maximum Value of Processed Records | SQLMDBCOUNTMAX | INT4 | 4 | ||
| DBCNT | SQL Monitor: DB Count Count | SQLMDBCOUNTCNT | INT4 | 4 | ||
| DBSUM | SQL Monitor: Total Processed Records | SQLMDBCOUNTSUM | DEC | 16 | ||
| DBSQS | SQL Monitor: DB Count Sum of Squares | SQLMDBCOUNTSQS | DEC | 16 | ||
| DBAVG | SQL Monitor: Mean Value of Processed Records | SQLMDBCOUNTAVG | DEC | 16 | ||
| DBDEV | SQL Monitor: Standard Deviation of Processed Records | SQLMDBCOUNTDEV | DEC | 16 | ||
| DDATE | Date for Runtime Monitor DATA entry | RTMDDATE | DATS | 16 | ||
| DTIME | Time for Runtime Monitor data entry | D_TIME | TIMS | 12 | ||
| RTMCNT | SQL Monitor: RTM Count | SQLMRTMCNT | INT4 | 4 |