SAP ABAP Table MSS_STMTHIST (Recorded overview of SQL Statement workload)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects
Basic Data
Table Category INTTAB    Structure 
Structure MSS_STMTHIST   Table Relationship Diagram
Short Description Recorded overview of SQL Statement workload    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 COLL_ID MSSSTMTHCOLLID   DEC 20   0   Unique ID of a set of collected expensive SQL Statements  
2 START_DT MSSSTMTHDT   DATS 8   0   Date when SQL Statement statistics were saved  
3 START_TM MSSSTMTHTM   TIMS 6   0   Time when SQL Statement statistics were saved  
4 SEC_SINCE MSSSTMTHSECSINCE INT4 INT4 10   0   Number of seconds since prior measurement  
5 CALLS MSSSTMTHCALLS   DEC 20   0   Number of SQL Statement executions during period  
6 PHYSRD MSSSTMTHPHYSRD   DEC 20   0   Physical reads during period  
7 LOGRD MSSSTMTHLOGRD   DEC 20   0   Logical reads during the period  
8 LOGWRT MSSSTMTHLOGWRT   DEC 20   0   Logical writes during the period  
9 ELPST MSSSTMTHELPST   DEC 20   0   Total elapsed time of all sql statements during the period  
10 CPU MSSSTMTHCPU   DEC 20   0   Total CPU of all statements during the period  
11 WAITRATIO MSSWAITHWTRATIO   DEC 10   3   Wait ratio during data collection period  
12 DCACHESZ MSSDATABASEPGS MSSCOLLMEMSIZE DEC 16   1   Datacache size in MB  
13 DCACHEHR MSSBUFHITRATIO MSSCOLLSLOPE DEC 16   3   Datacache hit ratio  
14 PCACHESZ MSSCACHESZ MSSCOLLMEMSIZE DEC 16   1   Size of whole SQL Server procedure cache  
15 PCACHEHR MSSCACHEHITRATIO MSSCOLLSLOPE DEC 16   3   Procedure cache hit ratio  
16 PLE MSSPGLIFEEXP   DEC 20   0   Page life expectancy  
17 PLOOKUPPERBATCH MSSBUFPGLOOKUPS MSSCOLLSLOPE DEC 16   3   Number of buffer page lookups per batch  
History
Last changed by/on SAP  20110908 
SAP Release Created in 703