SAP MSSQRYSTATSFROMDB table - Statistical info returned from sap_sys_dm_exec_query_stats details in SAP


SAP MSSQRYSTATSFROMDB table summary

Object Name: MSSQRYSTATSFROMDB
Dictionary Type: Structure
Description: Statistical info returned from sap_sys_dm_exec_query_stats


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

Details
MSSQRYSTATSFROMDB-SQLHANDLE table field - handle pointing to sql statment or procedure

Description: handle pointing to sql statment or procedure
Field Name: SQLHANDLE
Data Element: MSSSQLHANDLE
Data Type: CHAR
length (Dec): 130(0)
Check table:
Conversion Routine:
Domain Name: MSSHANDLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLHANDLE

MSSQRYSTATSFROMDB-EXEC_COUNT table field - Number of plan executions since last compile

Description: Number of plan executions since last compile
Field Name: EXEC_COUNT
Data Element: MSSEXECCOUNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXEC_COUNT

MSSQRYSTATSFROMDB-PCT_EXEC_COUNT table field - Percentage of server total execution counts

Description: Percentage of server total execution counts
Field Name: PCT_EXEC_COUNT
Data Element: MSSPCTEXECCNT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_EXEC_COUNT

MSSQRYSTATSFROMDB-TTL_CPU_TIME table field - Total amount of CPU time consumed by executions of this plan

Description: Total amount of CPU time consumed by executions of this plan
Field Name: TTL_CPU_TIME
Data Element: MSSTTLWORKERTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTL_CPU_TIME

MSSQRYSTATSFROMDB-PCT_CPU_TIME table field - Percent of total worker time

Description: Percent of total worker time
Field Name: PCT_CPU_TIME
Data Element: MSSPCTWORKERTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_CPU_TIME

MSSQRYSTATSFROMDB-AVG_CPU_TIME table field - Average amount of CPU time consumed by executions

Description: Average amount of CPU time consumed by executions
Field Name: AVG_CPU_TIME
Data Element: MSSAVGWORKERTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_CPU_TIME

MSSQRYSTATSFROMDB-LAST_CPU_TIME table field - CPU time consumed by last execution of this plan

Description: CPU time consumed by last execution of this plan
Field Name: LAST_CPU_TIME
Data Element: MSSLASTWORKERTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_CPU_TIME

MSSQRYSTATSFROMDB-MIN_CPU_TIME table field - Minimum CPU time consumed by this plan

Description: Minimum CPU time consumed by this plan
Field Name: MIN_CPU_TIME
Data Element: MSSMINWORKERTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MIN_CPU_TIME

MSSQRYSTATSFROMDB-MAX_CPU_TIME table field - Maximum CPU time consumed by this plan

Description: Maximum CPU time consumed by this plan
Field Name: MAX_CPU_TIME
Data Element: MSSMAXWORKERTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_CPU_TIME

MSSQRYSTATSFROMDB-TTL_PHYS_READS table field - Total physical reads for this plan

Description: Total physical reads for this plan
Field Name: TTL_PHYS_READS
Data Element: MSSTTLPHYSREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTL_PHYS_READS

MSSQRYSTATSFROMDB-PCT_PHYS_READS table field - Percent of all physical reads

Description: Percent of all physical reads
Field Name: PCT_PHYS_READS
Data Element: MSSPCTPHYSREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_PHYS_READS

MSSQRYSTATSFROMDB-AVG_PHYS_READS table field - Average physical reads for this plan

Description: Average physical reads for this plan
Field Name: AVG_PHYS_READS
Data Element: MSSAVGPHYSREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_PHYS_READS

MSSQRYSTATSFROMDB-LAST_PHYS_READS table field - Physical reads last time this plan executed

Description: Physical reads last time this plan executed
Field Name: LAST_PHYS_READS
Data Element: MSSLASTPHYSREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_PHYS_READS

MSSQRYSTATSFROMDB-MIN_PHYS_READS table field - Minimum number of physical reads for this plan

Description: Minimum number of physical reads for this plan
Field Name: MIN_PHYS_READS
Data Element: MSSMINPHYSREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MIN_PHYS_READS

MSSQRYSTATSFROMDB-MAX_PHYS_READS table field - Maximum number of physical reads for this plan

Description: Maximum number of physical reads for this plan
Field Name: MAX_PHYS_READS
Data Element: MSSMAXPHYSREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_PHYS_READS

MSSQRYSTATSFROMDB-TTL_LOG_WRITES table field - Total logical writes for this plan since compiled

Description: Total logical writes for this plan since compiled
Field Name: TTL_LOG_WRITES
Data Element: MSSTTLLOGWRITES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTL_LOG_WRITES

MSSQRYSTATSFROMDB-PCT_LOG_WRITES table field - Percentage of all logical writes

Description: Percentage of all logical writes
Field Name: PCT_LOG_WRITES
Data Element: MSSPCTLOGWRITES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_LOG_WRITES

MSSQRYSTATSFROMDB-AVG_LOG_WRITES table field - Average logical writes for this plan since compiled

Description: Average logical writes for this plan since compiled
Field Name: AVG_LOG_WRITES
Data Element: MSSAVGLOGWRITES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_LOG_WRITES

MSSQRYSTATSFROMDB-LAST_LOG_WRITES table field - Total logical writes for this plan since compiled

Description: Total logical writes for this plan since compiled
Field Name: LAST_LOG_WRITES
Data Element: MSSLASTLOGWRITES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_LOG_WRITES

MSSQRYSTATSFROMDB-MIN_LOG_WRITES table field - Minimum logical writes for this plan for a single execution

Description: Minimum logical writes for this plan for a single execution
Field Name: MIN_LOG_WRITES
Data Element: MSSMINLOGWRITES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MIN_LOG_WRITES

MSSQRYSTATSFROMDB-MAX_LOG_WRITES table field - Maximum logical writes for this plan for a single execution

Description: Maximum logical writes for this plan for a single execution
Field Name: MAX_LOG_WRITES
Data Element: MSSMAXLOGWRITES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_LOG_WRITES

MSSQRYSTATSFROMDB-TTL_LOGICAL_READS table field - Total logical reads for this plan since compiled

Description: Total logical reads for this plan since compiled
Field Name: TTL_LOGICAL_READS
Data Element: MSSTTLLOGICALREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTL_LOGICAL_READS

MSSQRYSTATSFROMDB-PCT_LOGICAL_READS table field - Percent of server wide logical reads

Description: Percent of server wide logical reads
Field Name: PCT_LOGICAL_READS
Data Element: MSSPCTLOGICALREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_LOGICAL_READS

MSSQRYSTATSFROMDB-AVG_LOGICAL_READS table field - Average logical reads for this plan since compiled

Description: Average logical reads for this plan since compiled
Field Name: AVG_LOGICAL_READS
Data Element: MSSAVGLOGICALREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_LOGICAL_READS

MSSQRYSTATSFROMDB-LAST_LOGICAL_READS table field - Last logical reads for this plan since compiled

Description: Last logical reads for this plan since compiled
Field Name: LAST_LOGICAL_READS
Data Element: MSSLASTLOGICALREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_LOGICAL_READS

MSSQRYSTATSFROMDB-MIN_LOGICAL_READS table field - Minimum number of logical reads this plan has ever performed

Description: Minimum number of logical reads this plan has ever performed
Field Name: MIN_LOGICAL_READS
Data Element: MSSMINLOGICALREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MIN_LOGICAL_READS

MSSQRYSTATSFROMDB-MAX_LOGICAL_READS table field - Maximum number of logical reads this plan has ever performed

Description: Maximum number of logical reads this plan has ever performed
Field Name: MAX_LOGICAL_READS
Data Element: MSSMAXLOGICALREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_LOGICAL_READS

MSSQRYSTATSFROMDB-TTL_ELAPSED_TIME table field - Total elapsed time in microseconds

Description: Total elapsed time in microseconds
Field Name: TTL_ELAPSED_TIME
Data Element: MSSTTLELAPSEDTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTL_ELAPSED_TIME

MSSQRYSTATSFROMDB-PCT_ELAPSED_TIME table field - Percentage of all server elapsed times

Description: Percentage of all server elapsed times
Field Name: PCT_ELAPSED_TIME
Data Element: MSSPCTELAPSEDTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_ELAPSED_TIME

MSSQRYSTATSFROMDB-AVG_ELAPSED_TIME table field - Average elapsed time in microseconds

Description: Average elapsed time in microseconds
Field Name: AVG_ELAPSED_TIME
Data Element: MSSAVGELAPSEDTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_ELAPSED_TIME

MSSQRYSTATSFROMDB-LAST_ELAPSED_TIME table field - Last elapsed time in microseconds

Description: Last elapsed time in microseconds
Field Name: LAST_ELAPSED_TIME
Data Element: MSSLASTELAPSEDTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_ELAPSED_TIME

MSSQRYSTATSFROMDB-MIN_ELAPSED_TIME table field - Minimum elapsed time in microseconds

Description: Minimum elapsed time in microseconds
Field Name: MIN_ELAPSED_TIME
Data Element: MSSMINELAPSEDTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MIN_ELAPSED_TIME

MSSQRYSTATSFROMDB-MAX_ELAPSED_TIME table field - Maximum elapsed time in microseconds

Description: Maximum elapsed time in microseconds
Field Name: MAX_ELAPSED_TIME
Data Element: MSSMAXELAPSEDTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_ELAPSED_TIME

MSSQRYSTATSFROMDB-TTL_CLR_TIME table field - Total amount of CLR time consumed by executions of this plan

Description: Total amount of CLR time consumed by executions of this plan
Field Name: TTL_CLR_TIME
Data Element: MSSTTLCLRTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTL_CLR_TIME

MSSQRYSTATSFROMDB-PCT_CLR_TIME table field - Percentage of overall CLR time

Description: Percentage of overall CLR time
Field Name: PCT_CLR_TIME
Data Element: MSSPCTCLRTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PCT_CLR_TIME

MSSQRYSTATSFROMDB-AVG_CLR_TIME table field - Average amount of CLR time in #s consumed by this plan

Description: Average amount of CLR time in #s consumed by this plan
Field Name: AVG_CLR_TIME
Data Element: MSSAVGCLRTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AVG_CLR_TIME

MSSQRYSTATSFROMDB-LAST_CLR_TIME table field - CLR time consumed by last execution of this plan

Description: CLR time consumed by last execution of this plan
Field Name: LAST_CLR_TIME
Data Element: MSSLASTCLRTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_CLR_TIME

MSSQRYSTATSFROMDB-MIN_CLR_TIME table field - Minimum CLR time consumed by this plan

Description: Minimum CLR time consumed by this plan
Field Name: MIN_CLR_TIME
Data Element: MSSMINCLRTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MIN_CLR_TIME

MSSQRYSTATSFROMDB-MAX_CLR_TIME table field - Maximum CLR time consumed by this plan

Description: Maximum CLR time consumed by this plan
Field Name: MAX_CLR_TIME
Data Element: MSSMAXCLRTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field MAX_CLR_TIME

MSSQRYSTATSFROMDB-WAIT_FACTOR table field - Elapsed time/CPU time

Description: Elapsed time/CPU time
Field Name: WAIT_FACTOR
Data Element: MSSWAITFACTOR
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WAIT_FACTOR

MSSQRYSTATSFROMDB-STMT_START_OFFSET table field - SQL Server int4

Description: SQL Server int4
Field Name: STMT_START_OFFSET
Data Element: MSSINT4
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_START_OFFSET

MSSQRYSTATSFROMDB-STMT_END_OFFSET table field - SQL Server int4

Description: SQL Server int4
Field Name: STMT_END_OFFSET
Data Element: MSSINT4
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STMT_END_OFFSET

MSSQRYSTATSFROMDB-SQLTEXT table field - First 50 characters of a SQL Server statement

Description: First 50 characters of a SQL Server statement
Field Name: SQLTEXT
Data Element: MSSPARTIALSQL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLTEXT

MSSQRYSTATSFROMDB-ABLOC table field - Abap location (string)

Description: Abap location (string)
Field Name: ABLOC
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ABLOC

MSSQRYSTATSFROMDB-PLAN_GEN_NUM table field - Number of times this plan has been recompiled

Description: Number of times this plan has been recompiled
Field Name: PLAN_GEN_NUM
Data Element: MSSPLANGENNUM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLAN_GEN_NUM

MSSQRYSTATSFROMDB-PLAN_HANDLE table field - handle pointing to plan used in execution of sql stmt/proc

Description: handle pointing to plan used in execution of sql stmt/proc
Field Name: PLAN_HANDLE
Data Element: MSSPLANHANDLE
Data Type: CHAR
length (Dec): 130(0)
Check table:
Conversion Routine:
Domain Name: MSSHANDLE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PLAN_HANDLE

MSSQRYSTATSFROMDB-CREATION_TIME table field - MS SQL Server time at which the plan was compiled.

Description: MS SQL Server time at which the plan was compiled.
Field Name: CREATION_TIME
Data Element: MSSPLANCRETIME
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATION_TIME

MSSQRYSTATSFROMDB-LAST_EXEC_TIME table field - MS SQL Server: Last time at which the plan was executed.

Description: MS SQL Server: Last time at which the plan was executed.
Field Name: LAST_EXEC_TIME
Data Element: MSSPLANEXECTIME
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: TEXT20
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_EXEC_TIME


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table