SAP ABAP Table MSSQUERYSTATSOUT (Query statistics on ALV in SQL Statements (sql >=9.0))

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	MSSQUERYSTATSOUT	Table Relationship Diagram
Short Description	Query statistics on ALV in SQL Statements (sql >=9.0)

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	.INCLUDE	☐				0	0	Statistical information related to CPU time/memory for query
2	SQLHANDLE	☐	MSSSQLHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to sql statment or procedure
3	OBJECT_NAME	☐	MSSOBJNAME	TEXT30	CHAR	30	0	MS SQL Server object name
4	EXEC_COUNT	☐	MSSEXECCOUNT		DEC	20	0	Number of plan executions since last compile
5	PCT_EXEC_COUNT	☐	MSSPCTEXECCNT		DEC	5	2	Percentage of server total execution counts
6	TTL_LOGICAL_READS	☐	MSSTTLLOGICALREADS		DEC	20	0	Total logical reads for this plan since compiled
7	PCT_LOGICAL_READS	☐	MSSPCTLOGICALREADS		DEC	5	2	Percent of server wide logical reads
8	AVG_LOGICAL_READS	☐	MSSAVGLOGICALREADS		DEC	20	0	Average logical reads for this plan since compiled
9	MAX_LOGICAL_READS	☐	MSSMAXLOGICALREADS		DEC	20	0	Maximum number of logical reads this plan has ever performed
10	MIN_LOGICAL_READS	☐	MSSMINLOGICALREADS		DEC	20	0	Minimum number of logical reads this plan has ever performed
11	LAST_LOGICAL_READS	☐	MSSLASTLOGICALREADS		DEC	20	0	Last logical reads for this plan since compiled
12	TTL_ELAPSED_TIME	☐	MSSTTLELAPSEDTIME		DEC	20	0	Total elapsed time in microseconds
13	PCT_ELAPSED_TIME	☐	MSSPCTELAPSEDTIME		DEC	5	2	Percentage of all server elapsed times
14	AVG_ELAPSED_TIME	☐	MSSAVGELAPSEDTIME		DEC	20	0	Average elapsed time in microseconds
15	MAX_ELAPSED_TIME	☐	MSSMAXELAPSEDTIME		DEC	20	0	Maximum elapsed time in microseconds
16	MIN_ELAPSED_TIME	☐	MSSMINELAPSEDTIME		DEC	20	0	Minimum elapsed time in microseconds
17	LAST_ELAPSED_TIME	☐	MSSLASTELAPSEDTIME		DEC	20	0	Last elapsed time in microseconds
18	ET_PER_ROW	☐	MSSETPERROW		DEC	20	0	Elapsed time in microseconds per row
19	TTL_CPU_TIME	☐	MSSTTLWORKERTIME		DEC	20	0	Total amount of CPU time consumed by executions of this plan
20	PCT_CPU_TIME	☐	MSSPCTWORKERTIME		DEC	5	2	Percent of total worker time
21	AVG_CPU_TIME	☐	MSSAVGWORKERTIME		DEC	20	0	Average amount of CPU time consumed by executions
22	MAX_CPU_TIME	☐	MSSMAXWORKERTIME		DEC	20	0	Maximum CPU time consumed by this plan
23	MIN_CPU_TIME	☐	MSSMINWORKERTIME		DEC	20	0	Minimum CPU time consumed by this plan
24	LAST_CPU_TIME	☐	MSSLASTWORKERTIME		DEC	20	0	CPU time consumed by last execution of this plan
25	TTL_PHYS_READS	☐	MSSTTLPHYSREADS		DEC	20	0	Total physical reads for this plan
26	PCT_PHYS_READS	☐	MSSPCTPHYSREADS		DEC	5	2	Percent of all physical reads
27	AVG_PHYS_READS	☐	MSSAVGPHYSREADS		DEC	20	0	Average physical reads for this plan
28	MAX_PHYS_READS	☐	MSSMAXPHYSREADS		DEC	20	0	Maximum number of physical reads for this plan
29	MIN_PHYS_READS	☐	MSSMINPHYSREADS		DEC	20	0	Minimum number of physical reads for this plan
30	LAST_PHYS_READS	☐	MSSLASTPHYSREADS		DEC	20	0	Physical reads last time this plan executed
31	TTL_LOG_WRITES	☐	MSSTTLLOGWRITES		DEC	20	0	Total logical writes for this plan since compiled
32	PCT_LOG_WRITES	☐	MSSPCTLOGWRITES		DEC	5	2	Percentage of all logical writes
33	AVG_LOG_WRITES	☐	MSSAVGLOGWRITES		DEC	20	0	Average logical writes for this plan since compiled
34	MAX_LOG_WRITES	☐	MSSMAXLOGWRITES		DEC	20	0	Maximum logical writes for this plan for a single execution
35	MIN_LOG_WRITES	☐	MSSMINLOGWRITES		DEC	20	0	Minimum logical writes for this plan for a single execution
36	LAST_LOG_WRITES	☐	MSSLASTLOGWRITES		DEC	20	0	Total logical writes for this plan since compiled
37	TTL_CLR_TIME	☐	MSSTTLCLRTIME		DEC	20	0	Total amount of CLR time consumed by executions of this plan
38	PCT_CLR_TIME	☐	MSSPCTCLRTIME		DEC	5	2	Percentage of overall CLR time
39	AVG_CLR_TIME	☐	MSSAVGCLRTIME		DEC	20	0	Average amount of CLR time consumed by this plan
40	MAX_CLR_TIME	☐	MSSMAXCLRTIME		DEC	20	0	Maximum CLR time consumed by this plan
41	MIN_CLR_TIME	☐	MSSMINCLRTIME		DEC	20	0	Minimum CLR time consumed by this plan
42	LAST_CLR_TIME	☐	MSSLASTCLRTIME		DEC	20	0	CLR time consumed by last execution of this plan
43	TTL_ROWS	☐	MSSTTLROWS		DEC	20	0	Total number of rows returned for a query plan
44	AVG_ROWS	☐	MSSAVGROWS		DEC	20	0	Average rows returned per execution
45	MAX_ROWS	☐	MSSMAXQROWS		DEC	20	0	Maximun number of rows returned for a query plan
46	MIN_ROWS	☐	MSSMINQROWS		DEC	20	0	Minimum number of rows returned for a query plan
47	LAST_ROWS	☐	MSSLASTROWS		DEC	20	0	Total number of rows returned for a query plan
48	WAIT_FACTOR	☐	MSSWAITFACTOR		DEC	20	0	Elapsed time/CPU time
49	EXECS_PER_HOUR	☐	MSSEXECSPH		DEC	16	3	Executions per hour
50	STMT_START_OFFSET	☐	MSSSTARTOFFSET	INT4	INT4	10	0	Start statement offset
51	STMT_END_OFFSET	☐	MSSENDOFFSET	INT4	INT4	10	0	Statement end offset
52	SQLTEXT	☐	MSSPARTIALSQL	TEXT50	CHAR	50	0	First 50 characters of a SQL Server statement
53	ABAP_NAME	☐	MSSABNAME	PROGNAME	CHAR	40	0	Name of the ABAP report
54	ABAP_LOC	☐	ABP_CONT		INT4	10	0	Offset of a Processing Control Block
55	PLAN_GEN_NUM	☐	MSSPLANGENNUM		DEC	20	0	Number of times this plan has been recompiled
56	PLAN_HANDLE	☐	MSSPLANHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to plan used in execution of sql stmt/proc
57	CREATION_TIME	☐	MSSPLANCRETIME	TEXT20	CHAR	20	0	MS SQL Server time at which the plan was compiled.
58	LAST_EXEC_TIME	☐	MSSPLANEXECTIME	TEXT20	CHAR	20	0	MS SQL Server: Last time at which the plan was executed.
59	TABLE_LIST	☐	MSSCSTABLIST		CHAR	1000	0	Comma separated table list
60	GROUP_BY	☐	MSSGRPBY		DEC	15	0	Sum of values with which to perform grouping

History

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