Data Element list used by SAP ABAP Table MSSQUERYSTATS (Statistical information related to CPU time/memory for query)
SAP ABAP Table MSSQUERYSTATS (Statistical information related to CPU time/memory for query) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | ABP_CONT | Offset of a Processing Control Block | |
2 | Data Element | MSSABNAME | Name of the ABAP report | |
3 | Data Element | MSSAVGCLRTIME | Average amount of CLR time consumed by this plan | |
4 | Data Element | MSSAVGELAPSEDTIME | Average elapsed time in microseconds | |
5 | Data Element | MSSAVGLOGICALREADS | Average logical reads for this plan since compiled | |
6 | Data Element | MSSAVGLOGWRITES | Average logical writes for this plan since compiled | |
7 | Data Element | MSSAVGPHYSREADS | Average physical reads for this plan | |
8 | Data Element | MSSAVGROWS | Average rows returned per execution | |
9 | Data Element | MSSAVGWORKERTIME | Average amount of CPU time consumed by executions | |
10 | Data Element | MSSCSTABLIST | Comma separated table list | |
11 | Data Element | MSSENDOFFSET | Statement end offset | |
12 | Data Element | MSSETPERROW | Elapsed time in microseconds per row | |
13 | Data Element | MSSEXECCOUNT | Number of plan executions since last compile | |
14 | Data Element | MSSEXECSPH | Executions per hour | |
15 | Data Element | MSSLASTCLRTIME | CLR time consumed by last execution of this plan | |
16 | Data Element | MSSLASTELAPSEDTIME | Last elapsed time in microseconds | |
17 | Data Element | MSSLASTLOGICALREADS | Last logical reads for this plan since compiled | |
18 | Data Element | MSSLASTLOGWRITES | Total logical writes for this plan since compiled | |
19 | Data Element | MSSLASTPHYSREADS | Physical reads last time this plan executed | |
20 | Data Element | MSSLASTROWS | Total number of rows returned for a query plan | |
21 | Data Element | MSSLASTWORKERTIME | CPU time consumed by last execution of this plan | |
22 | Data Element | MSSMAXCLRTIME | Maximum CLR time consumed by this plan | |
23 | Data Element | MSSMAXELAPSEDTIME | Maximum elapsed time in microseconds | |
24 | Data Element | MSSMAXLOGICALREADS | Maximum number of logical reads this plan has ever performed | |
25 | Data Element | MSSMAXLOGWRITES | Maximum logical writes for this plan for a single execution | |
26 | Data Element | MSSMAXPHYSREADS | Maximum number of physical reads for this plan | |
27 | Data Element | MSSMAXQROWS | Maximun number of rows returned for a query plan | |
28 | Data Element | MSSMAXWORKERTIME | Maximum CPU time consumed by this plan | |
29 | Data Element | MSSMINCLRTIME | Minimum CLR time consumed by this plan | |
30 | Data Element | MSSMINELAPSEDTIME | Minimum elapsed time in microseconds | |
31 | Data Element | MSSMINLOGICALREADS | Minimum number of logical reads this plan has ever performed | |
32 | Data Element | MSSMINLOGWRITES | Minimum logical writes for this plan for a single execution | |
33 | Data Element | MSSMINPHYSREADS | Minimum number of physical reads for this plan | |
34 | Data Element | MSSMINQROWS | Minimum number of rows returned for a query plan | |
35 | Data Element | MSSMINWORKERTIME | Minimum CPU time consumed by this plan | |
36 | Data Element | MSSOBJNAME | MS SQL Server object name | |
37 | Data Element | MSSPARTIALSQL | First 50 characters of a SQL Server statement | |
38 | Data Element | MSSPCTCLRTIME | Percentage of overall CLR time | |
39 | Data Element | MSSPCTELAPSEDTIME | Percentage of all server elapsed times | |
40 | Data Element | MSSPCTEXECCNT | Percentage of server total execution counts | |
41 | Data Element | MSSPCTLOGICALREADS | Percent of server wide logical reads | |
42 | Data Element | MSSPCTLOGWRITES | Percentage of all logical writes | |
43 | Data Element | MSSPCTPHYSREADS | Percent of all physical reads | |
44 | Data Element | MSSPCTWORKERTIME | Percent of total worker time | |
45 | Data Element | MSSPLANCRETIME | MS SQL Server time at which the plan was compiled. | |
46 | Data Element | MSSPLANEXECTIME | MS SQL Server: Last time at which the plan was executed. | |
47 | Data Element | MSSPLANGENNUM | Number of times this plan has been recompiled | |
48 | Data Element | MSSPLANHANDLE | handle pointing to plan used in execution of sql stmt/proc | |
49 | Data Element | MSSSQLHANDLE | handle pointing to sql statment or procedure | |
50 | Data Element | MSSSTARTOFFSET | Start statement offset | |
51 | Data Element | MSSTTLCLRTIME | Total amount of CLR time consumed by executions of this plan | |
52 | Data Element | MSSTTLELAPSEDTIME | Total elapsed time in microseconds | |
53 | Data Element | MSSTTLLOGICALREADS | Total logical reads for this plan since compiled | |
54 | Data Element | MSSTTLLOGWRITES | Total logical writes for this plan since compiled | |
55 | Data Element | MSSTTLPHYSREADS | Total physical reads for this plan | |
56 | Data Element | MSSTTLROWS | Total number of rows returned for a query plan | |
57 | Data Element | MSSTTLWORKERTIME | Total amount of CPU time consumed by executions of this plan | |
58 | Data Element | MSSWAITFACTOR | Elapsed time/CPU time |