SQLMSQ - SQL Monitor: Request / Snapshot
SQL Monitor: Request / Snapshot information is stored in SAP table SQLMSQ.
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 SQLMSQ
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOTID | SQL Monitor: Snapshot ID | X | SQLMSNAPSHOTID | RAW | 16 | |
| .INCLUDE | KEY | X | SQLMREQKEY | 0 | ||
| ROOTTYPE | SQL Monitor: Request Type | X | SQLMROOTTYPE | CHAR | 2 | |
| ROOTNAME | SQL Monitor: Request Entry Point (Transaction, etc.) | X | SQLMROOTNAME | CHAR | 120 | |
| .INCLUDE | PAYLOAD | SQLMREQPAYLOAD | 0 | |||
| WPTIMESUM | SQL Monitor: Total Time in Workprocesses [ms] | SQLMREQWPTIMESUM | DEC | 16 | ||
| DBTIMESUM | SQL Monitor: Total Database Execution Time [ms] | SQLMREQDBTIMESUM | DEC | 16 | ||
| ROLLAREACNT | SQL Monitor: Number of Internal Sessions | SQLMREQROLLAREACNT | INT4 | 4 |