Data Element list used by SAP ABAP Table MSS_STMTHIST (Recorded overview of SQL Statement workload)
SAP ABAP Table 
MSS_STMTHIST (Recorded overview of SQL Statement workload) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
MSSBUFHITRATIO | Datacache hit ratio | |
| 2 | Data Element |
MSSBUFPGLOOKUPS | Number of buffer page lookups per batch | |
| 3 | Data Element |
MSSCACHEHITRATIO | Procedure cache hit ratio | |
| 4 | Data Element |
MSSCACHESZ | Size of whole SQL Server procedure cache | |
| 5 | Data Element |
MSSDATABASEPGS | Datacache size in MB | |
| 6 | Data Element |
MSSPGLIFEEXP | Page life expectancy | |
| 7 | Data Element |
MSSSTMTHCALLS | Number of SQL Statement executions during period | |
| 8 | Data Element |
MSSSTMTHCOLLID | Unique ID of a set of collected expensive SQL Statements | |
| 9 | Data Element |
MSSSTMTHCPU | Total CPU of all statements during the period | |
| 10 | Data Element |
MSSSTMTHDT | Date when SQL Statement statistics were saved | |
| 11 | Data Element |
MSSSTMTHELPST | Total elapsed time of all sql statements during the period | |
| 12 | Data Element |
MSSSTMTHLOGRD | Logical reads during the period | |
| 13 | Data Element |
MSSSTMTHLOGWRT | Logical writes during the period | |
| 14 | Data Element |
MSSSTMTHPHYSRD | Physical reads during period | |
| 15 | Data Element |
MSSSTMTHSECSINCE | Number of seconds since prior measurement | |
| 16 | Data Element |
MSSSTMTHTM | Time when SQL Statement statistics were saved | |
| 17 | Data Element |
MSSWAITHWTRATIO | Wait ratio during data collection period |
