SAP MSSQUERYSTATS table - Statistical information related to CPU time/memory for query details in SAP


SAP MSSQUERYSTATS table summary

Object Name: MSSQUERYSTATS
Dictionary Type: Structure
Description: Statistical information related to CPU time/memory for query


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

Details
MSSQUERYSTATS-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

MSSQUERYSTATS-OBJECT_NAME table field - MS SQL Server object name

Description: MS SQL Server object name
Field Name: OBJECT_NAME
Data Element: MSSOBJNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECT_NAME

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-ET_PER_ROW table field - Elapsed time in microseconds per row

Description: Elapsed time in microseconds per row
Field Name: ET_PER_ROW
Data Element: MSSETPERROW
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ET_PER_ROW

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-TTL_ROWS table field - Total number of rows returned for a query plan

Description: Total number of rows returned for a query plan
Field Name: TTL_ROWS
Data Element: MSSTTLROWS
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_ROWS

MSSQUERYSTATS-AVG_ROWS table field - Average rows returned per execution

Description: Average rows returned per execution
Field Name: AVG_ROWS
Data Element: MSSAVGROWS
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_ROWS

MSSQUERYSTATS-MAX_ROWS table field - Maximun number of rows returned for a query plan

Description: Maximun number of rows returned for a query plan
Field Name: MAX_ROWS
Data Element: MSSMAXQROWS
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_ROWS

MSSQUERYSTATS-MIN_ROWS table field - Minimum number of rows returned for a query plan

Description: Minimum number of rows returned for a query plan
Field Name: MIN_ROWS
Data Element: MSSMINQROWS
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_ROWS

MSSQUERYSTATS-LAST_ROWS table field - Total number of rows returned for a query plan

Description: Total number of rows returned for a query plan
Field Name: LAST_ROWS
Data Element: MSSLASTROWS
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_ROWS

MSSQUERYSTATS-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

MSSQUERYSTATS-EXECS_PER_HOUR table field - Executions per hour

Description: Executions per hour
Field Name: EXECS_PER_HOUR
Data Element: MSSEXECSPH
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EXECS_PER_HOUR

MSSQUERYSTATS-STMT_START_OFFSET table field - Start statement offset

Description: Start statement offset
Field Name: STMT_START_OFFSET
Data Element: MSSSTARTOFFSET
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 STMT_START_OFFSET

MSSQUERYSTATS-STMT_END_OFFSET table field - Statement end offset

Description: Statement end offset
Field Name: STMT_END_OFFSET
Data Element: MSSENDOFFSET
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 STMT_END_OFFSET

MSSQUERYSTATS-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

MSSQUERYSTATS-ABAP_NAME table field - Name of the ABAP report

Description: Name of the ABAP report
Field Name: ABAP_NAME
Data Element: MSSABNAME
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: PROGNAME
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ABAP_NAME

MSSQUERYSTATS-ABAP_LOC table field - Offset of a Processing Control Block

Description: Offset of a Processing Control Block
Field Name: ABAP_LOC
Data Element: ABP_CONT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ABAP_LOC

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-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

MSSQUERYSTATS-TABLE_LIST table field - Comma separated table list

Description: Comma separated table list
Field Name: TABLE_LIST
Data Element: MSSCSTABLIST
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLE_LIST

MSSQUERYSTATS-TOTAL_DOP table field - Total DOP a plan used after it was compiled

Description: Total DOP a plan used after it was compiled
Field Name: TOTAL_DOP
Data Element: MSSTOTALDOP
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTAL_DOP

MSSQUERYSTATS-LAST_DOP table field - DOP a plan used last time in was run

Description: DOP a plan used last time in was run
Field Name: LAST_DOP
Data Element: MSSLASTDOP
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_DOP

MSSQUERYSTATS-MIN_DOP table field - Minimum DOP a plan ever used in a run

Description: Minimum DOP a plan ever used in a run
Field Name: MIN_DOP
Data Element: MSSMINDOP
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_DOP

MSSQUERYSTATS-MAX_DOP table field - Maximum degree of parallelism for a workload group

Description: Maximum degree of parallelism for a workload group
Field Name: MAX_DOP
Data Element: MSSMAXDOP
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 MAX_DOP

MSSQUERYSTATS-TOTAL_GRANT_KB table field - Total memory grant kb plan received after compiled

Description: Total memory grant kb plan received after compiled
Field Name: TOTAL_GRANT_KB
Data Element: MSSTTLGRANTKB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTAL_GRANT_KB

MSSQUERYSTATS-LAST_GRANT_KB table field - Memory grant kb plan received last time it ran

Description: Memory grant kb plan received last time it ran
Field Name: LAST_GRANT_KB
Data Element: MSSLASTGRANTKB
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_GRANT_KB

MSSQUERYSTATS-MIN_GRANT_KB table field - Minimum memory grant plan received during a run

Description: Minimum memory grant plan received during a run
Field Name: MIN_GRANT_KB
Data Element: MSSMINGRANTKB
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_GRANT_KB

MSSQUERYSTATS-MAX_GRANT_KB table field - Maximum memory grant plan received during a run

Description: Maximum memory grant plan received during a run
Field Name: MAX_GRANT_KB
Data Element: MSSMAXGRANTKB
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_GRANT_KB

MSSQUERYSTATS-TOTAL_USED_GRANT_KB table field - Total reserved memory grant plan used after compiled

Description: Total reserved memory grant plan used after compiled
Field Name: TOTAL_USED_GRANT_KB
Data Element: MSSTTLUSEDGRANTKB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTAL_USED_GRANT_KB

MSSQUERYSTATS-LAST_USED_GRANT_KB table field - The used memory grant plan used after last time it ran

Description: The used memory grant plan used after last time it ran
Field Name: LAST_USED_GRANT_KB
Data Element: MSSLASTUSEDGRANTKB
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_USED_GRANT_KB

MSSQUERYSTATS-MIN_USED_GRANT_KB table field - Minimum used memory grant plan ever used during a run

Description: Minimum used memory grant plan ever used during a run
Field Name: MIN_USED_GRANT_KB
Data Element: MSSMINUSEDGRANTKB
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_USED_GRANT_KB

MSSQUERYSTATS-MAX_USED_GRANT_KB table field - Maximum used memory grant plan ever used during a run

Description: Maximum used memory grant plan ever used during a run
Field Name: MAX_USED_GRANT_KB
Data Element: MSSMAXUSEDGRANTKB
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_USED_GRANT_KB

MSSQUERYSTATS-TOTAL_IDEAL_GRANT_KB table field - Total ideal memory grant kb plan received after compiled

Description: Total ideal memory grant kb plan received after compiled
Field Name: TOTAL_IDEAL_GRANT_KB
Data Element: MSSTTLIDEALKB
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTAL_IDEAL_GRANT_KB

MSSQUERYSTATS-LAST_IDEAL_GRANT_KB table field - Ideal memory grant kb plan received last time it ran

Description: Ideal memory grant kb plan received last time it ran
Field Name: LAST_IDEAL_GRANT_KB
Data Element: MSSLASTIDEALKB
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_IDEAL_GRANT_KB

MSSQUERYSTATS-MIN_IDEAL_GRANT_KB table field - Minimum ideal memory grant kb plan received lduring a run

Description: Minimum ideal memory grant kb plan received lduring a run
Field Name: MIN_IDEAL_GRANT_KB
Data Element: MSSMINIDEALKB
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_IDEAL_GRANT_KB

MSSQUERYSTATS-MAX_IDEAL_GRANT_KB table field - Maximum ideal memory grant kb plan received during a run

Description: Maximum ideal memory grant kb plan received during a run
Field Name: MAX_IDEAL_GRANT_KB
Data Element: MSSMAXIDEALKB
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_IDEAL_GRANT_KB

MSSQUERYSTATS-TOTAL_RESERVED_THREADS table field - Total reserved parallel threads plan used after compiled

Description: Total reserved parallel threads plan used after compiled
Field Name: TOTAL_RESERVED_THREADS
Data Element: MSSTTLRESTHREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTAL_RESERVED_THREADS

MSSQUERYSTATS-LAST_RESERVED_THREADS table field - Reserved parallel threads plan used last time plan ran

Description: Reserved parallel threads plan used last time plan ran
Field Name: LAST_RESERVED_THREADS
Data Element: MSSLASTRESTHREADS
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_RESERVED_THREADS

MSSQUERYSTATS-MIN_RESERVED_THREADS table field - Minimum reserved parallel threads plan used during a run

Description: Minimum reserved parallel threads plan used during a run
Field Name: MIN_RESERVED_THREADS
Data Element: MSSMINRESTHREADS
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_RESERVED_THREADS

MSSQUERYSTATS-MAX_RESERVED_THREADS table field - Maximum reserved parallel threads plan used during a run

Description: Maximum reserved parallel threads plan used during a run
Field Name: MAX_RESERVED_THREADS
Data Element: MSSMAXRESTHREADS
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_RESERVED_THREADS

MSSQUERYSTATS-TOTAL_USED_THREADS table field - Total used parallel threads after plan compiled

Description: Total used parallel threads after plan compiled
Field Name: TOTAL_USED_THREADS
Data Element: MSSTTLUSEDTHREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TOTAL_USED_THREADS

MSSQUERYSTATS-LAST_USED_THREADS table field - The number of used parallel threads used in the last run

Description: The number of used parallel threads used in the last run
Field Name: LAST_USED_THREADS
Data Element: MSSLASTUSEDTHREADS
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_USED_THREADS

MSSQUERYSTATS-MIN_USED_THREADS table field - Minimum used parallel threads plan used during a run

Description: Minimum used parallel threads plan used during a run
Field Name: MIN_USED_THREADS
Data Element: MSSMINUSEDTHREADS
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_USED_THREADS

MSSQUERYSTATS-MAX_USED_THREADS table field - Maximum used parallel threads ever used during a run

Description: Maximum used parallel threads ever used during a run
Field Name: MAX_USED_THREADS
Data Element: MSSMAXUSEDTHREADS
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_USED_THREADS


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table