SAP MSS_STMTHIST table - Recorded overview of SQL Statement workload details in SAP


SAP MSS_STMTHIST table summary

Object Name: MSS_STMTHIST
Dictionary Type: Structure
Description: Recorded overview of SQL Statement workload


Field list for MSS_STMTHIST table on an S/4 SAP system

Details
MSS_STMTHIST-COLL_ID table field - Unique ID of a set of collected expensive SQL Statements

Description: Unique ID of a set of collected expensive SQL Statements
Field Name: COLL_ID
Data Element: MSSSTMTHCOLLID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLL_ID

MSS_STMTHIST-START_DT table field - Date when SQL Statement statistics were saved

Description: Date when SQL Statement statistics were saved
Field Name: START_DT
Data Element: MSSSTMTHDT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_DT

MSS_STMTHIST-START_TM table field - Time when SQL Statement statistics were saved

Description: Time when SQL Statement statistics were saved
Field Name: START_TM
Data Element: MSSSTMTHTM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_TM

MSS_STMTHIST-SEC_SINCE table field - Number of seconds since prior measurement

Description: Number of seconds since prior measurement
Field Name: SEC_SINCE
Data Element: MSSSTMTHSECSINCE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEC_SINCE

MSS_STMTHIST-CALLS table field - Number of SQL Statement executions during period

Description: Number of SQL Statement executions during period
Field Name: CALLS
Data Element: MSSSTMTHCALLS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CALLS

MSS_STMTHIST-PHYSRD table field - Physical reads during period

Description: Physical reads during period
Field Name: PHYSRD
Data Element: MSSSTMTHPHYSRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PHYSRD

MSS_STMTHIST-LOGRD table field - Logical reads during the period

Description: Logical reads during the period
Field Name: LOGRD
Data Element: MSSSTMTHLOGRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGRD

MSS_STMTHIST-LOGWRT table field - Logical writes during the period

Description: Logical writes during the period
Field Name: LOGWRT
Data Element: MSSSTMTHLOGWRT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGWRT

MSS_STMTHIST-ELPST table field - Total elapsed time of all sql statements during the period

Description: Total elapsed time of all sql statements during the period
Field Name: ELPST
Data Element: MSSSTMTHELPST
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ELPST

MSS_STMTHIST-CPU table field - Total CPU of all statements during the period

Description: Total CPU of all statements during the period
Field Name: CPU
Data Element: MSSSTMTHCPU
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CPU

MSS_STMTHIST-WAITRATIO table field - Wait ratio during data collection period

Description: Wait ratio during data collection period
Field Name: WAITRATIO
Data Element: MSSWAITHWTRATIO
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAITRATIO

MSS_STMTHIST-DCACHESZ table field - Datacache size in MB

Description: Datacache size in MB
Field Name: DCACHESZ
Data Element: MSSDATABASEPGS
Data Type: DEC
length (Dec): 16(1)
Check table:
Conversion Routine:
Domain Name: MSSCOLLMEMSIZE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DCACHESZ

MSS_STMTHIST-DCACHEHR table field - Datacache hit ratio

Description: Datacache hit ratio
Field Name: DCACHEHR
Data Element: MSSBUFHITRATIO
Data Type: DEC
length (Dec): 16(3)
Check table:
Conversion Routine:
Domain Name: MSSCOLLSLOPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DCACHEHR

MSS_STMTHIST-PCACHESZ table field - Size of whole SQL Server procedure cache

Description: Size of whole SQL Server procedure cache
Field Name: PCACHESZ
Data Element: MSSCACHESZ
Data Type: DEC
length (Dec): 16(1)
Check table:
Conversion Routine:
Domain Name: MSSCOLLMEMSIZE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCACHESZ

MSS_STMTHIST-PCACHEHR table field - Procedure cache hit ratio

Description: Procedure cache hit ratio
Field Name: PCACHEHR
Data Element: MSSCACHEHITRATIO
Data Type: DEC
length (Dec): 16(3)
Check table:
Conversion Routine:
Domain Name: MSSCOLLSLOPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCACHEHR

MSS_STMTHIST-PLE table field - Page life expectancy

Description: Page life expectancy
Field Name: PLE
Data Element: MSSPGLIFEEXP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLE

MSS_STMTHIST-PLOOKUPPERBATCH table field - Number of buffer page lookups per batch

Description: Number of buffer page lookups per batch
Field Name: PLOOKUPPERBATCH
Data Element: MSSBUFPGLOOKUPS
Data Type: DEC
length (Dec): 16(3)
Check table:
Conversion Routine:
Domain Name: MSSCOLLSLOPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLOOKUPPERBATCH


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table