SAP ABAP Table MSS_STMTHISTDET (History details for an expensive SQL statement)

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	MSS_STMTHISTDET	Table Relationship Diagram
Short Description	History details for an expensive SQL statement

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	STW_ID	☐	MSSSTMTHCOLLID		DEC	20	0	Unique ID of a set of collected expensive SQL Statements
2	STW_COLLID	☐	MSSSTMTHCOLLID		DEC	20	0	Unique ID of a set of collected expensive SQL Statements
3	COLL_DT	☐	MSSSTMTHDT		DATS	8	0	Date when SQL Statement statistics were saved
4	COLL_TM	☐	MSSSTMTHTM		TIMS	6	0	Time when SQL Statement statistics were saved
5	HIGH_ELAP	☐	MSSELAPFLAG	CHAR1	CHAR	1	0	High elapsed time
6	PCT_ELAPSED_TIME	☐	MSSPCTELAPSEDTIME		DEC	5	2	Percentage of all server elapsed times
7	HIGH_CALLS	☐	MSSCALLSFLAG	CHAR1	CHAR	1	0	Flag set if statement was included because of # of calls
8	PCT_EXEC_COUNT	☐	MSSPCTEXECCNT		DEC	5	2	Percentage of server total execution counts
9	HIGH_PHYRD	☐	MSSPHYRDFLAG	CHAR1	CHAR	1	0	Statement included because of high physical reads
10	PCT_PHYS_READS	☐	MSSPCTPHYSREADS		DEC	5	2	Percent of all physical reads
11	HIGH_LOGRD	☐	MSSLOGRDFLAG	CHAR1	CHAR	1	0	High logical reads for this statement
12	PCT_LOGICAL_READS	☐	MSSPCTLOGICALREADS		DEC	5	2	Percent of server wide logical reads
13	HIGH_LOGWR	☐	MSSLOGWRFLAG	CHAR1	CHAR	1	0	Statement has high logical writes
14	PCT_LOG_WRITES	☐	MSSPCTLOGWRITES		DEC	5	2	Percentage of all logical writes
15	HIGH_CPU	☐	MSSCPUFLAG	CHAR1	CHAR	1	0	High CPU time
16	PCT_CPU_TIME	☐	MSSPCTWORKERTIME		DEC	5	2	Percent of total worker time
17	SQLTEXT	☐	MSSPARTIALSQL	TEXT50	CHAR	50	0	First 50 characters of a SQL Server statement
18	SQLHANDLE	☐	MSSSQLHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to sql statment or procedure
19	PLANHANDLE	☐	MSSPLANHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to plan used in execution of sql stmt/proc
20	OBJ_NAME	☐	MSSOBJNAME	TEXT30	CHAR	30	0	MS SQL Server object name
21	EXEC_COUNT	☐	MSSEXECCOUNT		DEC	20	0	Number of plan executions since last compile
22	TTL_LOGICAL_READS	☐	MSSTTLLOGICALREADS		DEC	20	0	Total logical reads for this plan since compiled
23	AVG_LOGICAL_READS	☐	MSSAVGLOGICALREADS		DEC	20	0	Average logical reads for this plan since compiled
24	MAX_LOGICAL_READS	☐	MSSMAXLOGICALREADS		DEC	20	0	Maximum number of logical reads this plan has ever performed
25	MIN_LOGICAL_READS	☐	MSSMINLOGICALREADS		DEC	20	0	Minimum number of logical reads this plan has ever performed
26	LAST_LOGICAL_READS	☐	MSSLASTLOGICALREADS		DEC	20	0	Last logical reads for this plan since compiled
27	TTL_ELAPSED_TIME	☐	MSSTTLELAPSEDTIME		DEC	20	0	Total elapsed time in microseconds
28	AVG_ELAPSED_TIME	☐	MSSAVGELAPSEDTIME		DEC	20	0	Average elapsed time in microseconds
29	MAX_ELAPSED_TIME	☐	MSSMAXELAPSEDTIME		DEC	20	0	Maximum elapsed time in microseconds
30	MIN_ELAPSED_TIME	☐	MSSMINELAPSEDTIME		DEC	20	0	Minimum elapsed time in microseconds
31	LAST_ELAPSED_TIME	☐	MSSLASTELAPSEDTIME		DEC	20	0	Last elapsed time in microseconds
32	ET_PER_ROW	☐	MSSETPERROW		DEC	20	0	Elapsed time in microseconds per row
33	TTL_ROWS	☐	MSSTTLROWS		DEC	20	0	Total number of rows returned for a query plan
34	AVG_ROWS	☐	MSSAVGROWS		DEC	20	0	Average rows returned per execution
35	MAX_ROWS	☐	MSSMAXQROWS		DEC	20	0	Maximun number of rows returned for a query plan
36	MIN_ROWS	☐	MSSMINQROWS		DEC	20	0	Minimum number of rows returned for a query plan
37	LAST_ROWS	☐	MSSLASTROWS		DEC	20	0	Total number of rows returned for a query plan
38	AVG_CPU_TIME	☐	MSSAVGWORKERTIME		DEC	20	0	Average amount of CPU time consumed by executions
39	MAX_CPU_TIME	☐	MSSMAXWORKERTIME		DEC	20	0	Maximum CPU time consumed by this plan
40	MIN_CPU_TIME	☐	MSSMINWORKERTIME		DEC	20	0	Minimum CPU time consumed by this plan
41	LAST_CPU_TIME	☐	MSSLASTWORKERTIME		DEC	20	0	CPU time consumed by last execution of this plan
42	TTL_PHYS_READS	☐	MSSTTLPHYSREADS		DEC	20	0	Total physical reads for this plan
43	AVG_PHYS_READS	☐	MSSAVGPHYSREADS		DEC	20	0	Average physical reads for this plan
44	MAX_PHYS_READS	☐	MSSMAXPHYSREADS		DEC	20	0	Maximum number of physical reads for this plan
45	MIN_PHYS_READS	☐	MSSMINPHYSREADS		DEC	20	0	Minimum number of physical reads for this plan
46	LAST_PHYS_READS	☐	MSSLASTPHYSREADS		DEC	20	0	Physical reads last time this plan executed
47	TTL_LOG_WRITES	☐	MSSTTLLOGWRITES		DEC	20	0	Total logical writes for this plan since compiled
48	AVG_LOG_WRITES	☐	MSSAVGLOGWRITES		DEC	20	0	Average logical writes for this plan since compiled
49	MAX_LOG_WRITES	☐	MSSMAXLOGWRITES		DEC	20	0	Maximum logical writes for this plan for a single execution
50	MIN_LOG_WRITES	☐	MSSMINLOGWRITES		DEC	20	0	Minimum logical writes for this plan for a single execution
51	LAST_LOG_WRITES	☐	MSSLASTLOGWRITES		DEC	20	0	Total logical writes for this plan since compiled
52	WAIT_FACTOR	☐	MSSWAITFACTOR		DEC	20	0	Elapsed time/CPU time
53	EXECS_PER_HOUR	☐	MSSEXECSPH		DEC	16	3	Executions per hour
54	STMT_START_OFFSET	☐	MSSSTARTOFFSET	INT4	INT4	10	0	Start statement offset
55	STMT_END_OFFSET	☐	MSSENDOFFSET	INT4	INT4	10	0	Statement end offset
56	ABAP_NAME	☐	MSSABNAME	PROGNAME	CHAR	40	0	Name of the ABAP report
57	ABAP_LOC	☐	ABP_CONT		INT4	10	0	Offset of a Processing Control Block
58	PLAN_GEN_NUM	☐	MSSPLANGENNUM		DEC	20	0	Number of times this plan has been recompiled
59	CREATION_TIME	☐	MSSPLANCRETIME	TEXT20	CHAR	20	0	MS SQL Server time at which the plan was compiled.
60	LAST_EXEC_TIME	☐	MSSPLANEXECTIME	TEXT20	CHAR	20	0	MS SQL Server: Last time at which the plan was executed.
61	LINE_COLOR	☐			CHAR	4	0

History

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