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

  


SAP MSS_STMTHIST table summary

Warning: Undefined array key "id" in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 101

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


  

Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 234 Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 278 Warning: Undefined variable $obj1 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj2 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj3 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj4 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj5 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj6 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj7 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj8 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj9 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj10 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj11 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279


View list of all SAP tables(S4H/ECC)

Select data from SAP table