Data Element list used by SAP ABAP Table MSSQRYSTATSFROMDB (Statistical info returned from sap_sys_dm_exec_query_stats)
SAP ABAP Table 
MSSQRYSTATSFROMDB (Statistical info returned from sap_sys_dm_exec_query_stats) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
MSSAVGCLRTIME | Average amount of CLR time consumed by this plan | |
| 2 | Data Element |
MSSAVGELAPSEDTIME | Average elapsed time in microseconds | |
| 3 | Data Element |
MSSAVGLOGICALREADS | Average logical reads for this plan since compiled | |
| 4 | Data Element |
MSSAVGLOGWRITES | Average logical writes for this plan since compiled | |
| 5 | Data Element |
MSSAVGPHYSREADS | Average physical reads for this plan | |
| 6 | Data Element |
MSSAVGWORKERTIME | Average amount of CPU time consumed by executions | |
| 7 | Data Element |
MSSEXECCOUNT | Number of plan executions since last compile | |
| 8 | Data Element |
MSSINT4 | SQL Server int4 | |
| 9 | Data Element |
MSSINT4 | SQL Server int4 | |
| 10 | Data Element |
MSSLASTCLRTIME | CLR time consumed by last execution of this plan | |
| 11 | Data Element |
MSSLASTELAPSEDTIME | Last elapsed time in microseconds | |
| 12 | Data Element |
MSSLASTLOGICALREADS | Last logical reads for this plan since compiled | |
| 13 | Data Element |
MSSLASTLOGWRITES | Total logical writes for this plan since compiled | |
| 14 | Data Element |
MSSLASTPHYSREADS | Physical reads last time this plan executed | |
| 15 | Data Element |
MSSLASTWORKERTIME | CPU time consumed by last execution of this plan | |
| 16 | Data Element |
MSSMAXCLRTIME | Maximum CLR time consumed by this plan | |
| 17 | Data Element |
MSSMAXELAPSEDTIME | Maximum elapsed time in microseconds | |
| 18 | Data Element |
MSSMAXLOGICALREADS | Maximum number of logical reads this plan has ever performed | |
| 19 | Data Element |
MSSMAXLOGWRITES | Maximum logical writes for this plan for a single execution | |
| 20 | Data Element |
MSSMAXPHYSREADS | Maximum number of physical reads for this plan | |
| 21 | Data Element |
MSSMAXWORKERTIME | Maximum CPU time consumed by this plan | |
| 22 | Data Element |
MSSMINCLRTIME | Minimum CLR time consumed by this plan | |
| 23 | Data Element |
MSSMINELAPSEDTIME | Minimum elapsed time in microseconds | |
| 24 | Data Element |
MSSMINLOGICALREADS | Minimum number of logical reads this plan has ever performed | |
| 25 | Data Element |
MSSMINLOGWRITES | Minimum logical writes for this plan for a single execution | |
| 26 | Data Element |
MSSMINPHYSREADS | Minimum number of physical reads for this plan | |
| 27 | Data Element |
MSSMINWORKERTIME | Minimum CPU time consumed by this plan | |
| 28 | Data Element |
MSSPARTIALSQL | First 50 characters of a SQL Server statement | |
| 29 | Data Element |
MSSPCTCLRTIME | Percentage of overall CLR time | |
| 30 | Data Element |
MSSPCTELAPSEDTIME | Percentage of all server elapsed times | |
| 31 | Data Element |
MSSPCTEXECCNT | Percentage of server total execution counts | |
| 32 | Data Element |
MSSPCTLOGICALREADS | Percent of server wide logical reads | |
| 33 | Data Element |
MSSPCTLOGWRITES | Percentage of all logical writes | |
| 34 | Data Element |
MSSPCTPHYSREADS | Percent of all physical reads | |
| 35 | Data Element |
MSSPCTWORKERTIME | Percent of total worker time | |
| 36 | Data Element |
MSSPLANCRETIME | MS SQL Server time at which the plan was compiled. | |
| 37 | Data Element |
MSSPLANEXECTIME | MS SQL Server: Last time at which the plan was executed. | |
| 38 | Data Element |
MSSPLANGENNUM | Number of times this plan has been recompiled | |
| 39 | Data Element |
MSSPLANHANDLE | handle pointing to plan used in execution of sql stmt/proc | |
| 40 | Data Element |
MSSSQLHANDLE | handle pointing to sql statment or procedure | |
| 41 | Data Element |
MSSTTLCLRTIME | Total amount of CLR time consumed by executions of this plan | |
| 42 | Data Element |
MSSTTLELAPSEDTIME | Total elapsed time in microseconds | |
| 43 | Data Element |
MSSTTLLOGICALREADS | Total logical reads for this plan since compiled | |
| 44 | Data Element |
MSSTTLLOGWRITES | Total logical writes for this plan since compiled | |
| 45 | Data Element |
MSSTTLPHYSREADS | Total physical reads for this plan | |
| 46 | Data Element |
MSSTTLWORKERTIME | Total amount of CPU time consumed by executions of this plan | |
| 47 | Data Element |
MSSWAITFACTOR | Elapsed time/CPU time |
