SAP ABAP Table MSSQUERYSTATS (Statistical information related to CPU time/memory for query)

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	MSSQUERYSTATS	Table Relationship Diagram
Short Description	Statistical information related to CPU time/memory for query

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

History

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