SAP ABAP Table MSSQRYSTATSFROMDB (Statistical info returned from sap_sys_dm_exec_query_stats)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSSQRYSTATSFROMDB	Table Relationship Diagram
Short Description	Statistical info returned from sap_sys_dm_exec_query_stats

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SQLHANDLE	☐	MSSSQLHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to sql statment or procedure
2	EXEC_COUNT	☐	MSSEXECCOUNT		DEC	20	0	Number of plan executions since last compile
3	PCT_EXEC_COUNT	☐	MSSPCTEXECCNT		DEC	5	2	Percentage of server total execution counts
4	TTL_CPU_TIME	☐	MSSTTLWORKERTIME		DEC	20	0	Total amount of CPU time consumed by executions of this plan
5	PCT_CPU_TIME	☐	MSSPCTWORKERTIME		DEC	5	2	Percent of total worker time
6	AVG_CPU_TIME	☐	MSSAVGWORKERTIME		DEC	20	0	Average amount of CPU time consumed by executions
7	LAST_CPU_TIME	☐	MSSLASTWORKERTIME		DEC	20	0	CPU time consumed by last execution of this plan
8	MIN_CPU_TIME	☐	MSSMINWORKERTIME		DEC	20	0	Minimum CPU time consumed by this plan
9	MAX_CPU_TIME	☐	MSSMAXWORKERTIME		DEC	20	0	Maximum CPU time consumed by this plan
10	TTL_PHYS_READS	☐	MSSTTLPHYSREADS		DEC	20	0	Total physical reads for this plan
11	PCT_PHYS_READS	☐	MSSPCTPHYSREADS		DEC	5	2	Percent of all physical reads
12	AVG_PHYS_READS	☐	MSSAVGPHYSREADS		DEC	20	0	Average physical reads for this plan
13	LAST_PHYS_READS	☐	MSSLASTPHYSREADS		DEC	20	0	Physical reads last time this plan executed
14	MIN_PHYS_READS	☐	MSSMINPHYSREADS		DEC	20	0	Minimum number of physical reads for this plan
15	MAX_PHYS_READS	☐	MSSMAXPHYSREADS		DEC	20	0	Maximum number of physical reads for this plan
16	TTL_LOG_WRITES	☐	MSSTTLLOGWRITES		DEC	20	0	Total logical writes for this plan since compiled
17	PCT_LOG_WRITES	☐	MSSPCTLOGWRITES		DEC	5	2	Percentage of all logical writes
18	AVG_LOG_WRITES	☐	MSSAVGLOGWRITES		DEC	20	0	Average logical writes for this plan since compiled
19	LAST_LOG_WRITES	☐	MSSLASTLOGWRITES		DEC	20	0	Total logical writes for this plan since compiled
20	MIN_LOG_WRITES	☐	MSSMINLOGWRITES		DEC	20	0	Minimum logical writes for this plan for a single execution
21	MAX_LOG_WRITES	☐	MSSMAXLOGWRITES		DEC	20	0	Maximum logical writes for this plan for a single execution
22	TTL_LOGICAL_READS	☐	MSSTTLLOGICALREADS		DEC	20	0	Total logical reads for this plan since compiled
23	PCT_LOGICAL_READS	☐	MSSPCTLOGICALREADS		DEC	5	2	Percent of server wide logical reads
24	AVG_LOGICAL_READS	☐	MSSAVGLOGICALREADS		DEC	20	0	Average logical reads for this plan since compiled
25	LAST_LOGICAL_READS	☐	MSSLASTLOGICALREADS		DEC	20	0	Last logical reads for this plan since compiled
26	MIN_LOGICAL_READS	☐	MSSMINLOGICALREADS		DEC	20	0	Minimum number of logical reads this plan has ever performed
27	MAX_LOGICAL_READS	☐	MSSMAXLOGICALREADS		DEC	20	0	Maximum number of logical reads this plan has ever performed
28	TTL_ELAPSED_TIME	☐	MSSTTLELAPSEDTIME		DEC	20	0	Total elapsed time in microseconds
29	PCT_ELAPSED_TIME	☐	MSSPCTELAPSEDTIME		DEC	5	2	Percentage of all server elapsed times
30	AVG_ELAPSED_TIME	☐	MSSAVGELAPSEDTIME		DEC	20	0	Average elapsed time in microseconds
31	LAST_ELAPSED_TIME	☐	MSSLASTELAPSEDTIME		DEC	20	0	Last elapsed time in microseconds
32	MIN_ELAPSED_TIME	☐	MSSMINELAPSEDTIME		DEC	20	0	Minimum elapsed time in microseconds
33	MAX_ELAPSED_TIME	☐	MSSMAXELAPSEDTIME		DEC	20	0	Maximum elapsed time in microseconds
34	TTL_CLR_TIME	☐	MSSTTLCLRTIME		DEC	20	0	Total amount of CLR time consumed by executions of this plan
35	PCT_CLR_TIME	☐	MSSPCTCLRTIME		DEC	5	2	Percentage of overall CLR time
36	AVG_CLR_TIME	☐	MSSAVGCLRTIME		DEC	20	0	Average amount of CLR time consumed by this plan
37	LAST_CLR_TIME	☐	MSSLASTCLRTIME		DEC	20	0	CLR time consumed by last execution of this plan
38	MIN_CLR_TIME	☐	MSSMINCLRTIME		DEC	20	0	Minimum CLR time consumed by this plan
39	MAX_CLR_TIME	☐	MSSMAXCLRTIME		DEC	20	0	Maximum CLR time consumed by this plan
40	WAIT_FACTOR	☐	MSSWAITFACTOR		DEC	20	0	Elapsed time/CPU time
41	STMT_START_OFFSET	☐	MSSINT4		INT4	10	0	SQL Server int4
42	STMT_END_OFFSET	☐	MSSINT4		INT4	10	0	SQL Server int4
43	SQLTEXT	☐	MSSPARTIALSQL	TEXT50	CHAR	50	0	First 50 characters of a SQL Server statement
44	ABLOC	☐			CHAR	200	0
45	PLAN_GEN_NUM	☐	MSSPLANGENNUM		DEC	20	0	Number of times this plan has been recompiled
46	PLAN_HANDLE	☐	MSSPLANHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to plan used in execution of sql stmt/proc
47	CREATION_TIME	☐	MSSPLANCRETIME	TEXT20	CHAR	20	0	MS SQL Server time at which the plan was compiled.
48	LAST_EXEC_TIME	☐	MSSPLANEXECTIME	TEXT20	CHAR	20	0	MS SQL Server: Last time at which the plan was executed.

History

Last changed by/on	SAP	20140117
SAP Release Created in	710