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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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