Data Element list used by SAP ABAP Table MSSIDXOPSTATS (Index operational stats output from MSS_GET_INDEX_OP_STATS)
SAP ABAP Table MSSIDXOPSTATS (Index operational stats output from MSS_GET_INDEX_OP_STATS) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | MSSAVGPGLCKWAIT | Average pagelock wait ms | |
2 | Data Element | MSSAVGPGLTCHWAIT | Average page latch wait ms | |
3 | Data Element | MSSAVGROWLCKWAIT | Average rowlock wait ms | |
4 | Data Element | MSSAVGTOTLLWAIT | Average wait for a latch or a lock | |
5 | Data Element | MSSAVPGIOLTCHWAIT | Average page io latch wait | |
6 | Data Element | MSSCOLUMNVALUEPULLINROWCNT | Index op stats: Count of values pulled in-row | |
7 | Data Element | MSSCOLUMNVALUEPUSHOFFROWCNT | Index op stats: Count of values pushed off-row for a new row | |
8 | Data Element | MSSDB | Database name | |
9 | Data Element | MSSFORWARDEDFTCHCNT | Index op stats: Rows fetched through a forwarding record | |
10 | Data Element | MSSIDXOPTOTALOPS | Index op stats: Total operations on the index | |
11 | Data Element | MSSINDEX | Index name | |
12 | Data Element | MSSINDEXLCKPROMOTIONATTEMPTCNT | Index op stats: Index lock promotion attempts | |
13 | Data Element | MSSINDEXLCKPROMOTIONCNT | Index op stats: Index lock promotions | |
14 | Data Element | MSSLEAFALLOCCNT | Index op stats: Count of leaf-level page allocations | |
15 | Data Element | MSSLEAFDELCNT | Index op stats: Cumulative count of leaf-level deletes | |
16 | Data Element | MSSLEAFGHOSTCNT | Index op stats: Count of leaf-level rows marked for delete | |
17 | Data Element | MSSLEAFINSCNT | Index op stats: Cumulative count of leaf-level inserts | |
18 | Data Element | MSSLEAFPAGEMERGECNT | Index op stats: Count of page merges at the leaf level | |
19 | Data Element | MSSLEAFUPDCNT | Index op stats: Cumulative count of leaf-level updates | |
20 | Data Element | MSSLOBFTCHINBYTES | Index op stats: Count of LOB data bytes retrieved | |
21 | Data Element | MSSLOBFTCHINPAGES | Index op stats: Lob fetch pages | |
22 | Data Element | MSSLOBORPHANCREATECNT | Index op stats: Count of orphan LOB created | |
23 | Data Element | MSSLOBORPHANINSCNT | Index op stats:Orphan LOB values inserted during bulkop | |
24 | Data Element | MSSNONLEAFALLOCCNT | Index op stats: Count of non leaf-level page allocations | |
25 | Data Element | MSSNONLEAFDELCNT | Index op stats: Count of deletes above the leaf level | |
26 | Data Element | MSSNONLEAFINSCNT | Index op stats: Count of inserts above the leaf level | |
27 | Data Element | MSSNONLEAFPAGEMERGECNT | Index op stats: Count of page merges above the leaf level | |
28 | Data Element | MSSNONLEAFUPDCNT | Index op stats: Count of updates above the leaf level | |
29 | Data Element | MSSPAGEIOLTCHWAITCNT | Index op stats: I/O page latch wait count | |
30 | Data Element | MSSPAGEIOLTCHWAITMS | Index op stats: I/O page latch wait in ms | |
31 | Data Element | MSSPAGELCKCNT | Index op stats: Page lock count | |
32 | Data Element | MSSPAGELCKWAITCNT | Index op stats: Page lock wait count | |
33 | Data Element | MSSPAGELCKWAITMS | Index op stats: Page lock wait in milliseconds | |
34 | Data Element | MSSPAGELTCHWAITCNT | Index op stats: Latch wait count | |
35 | Data Element | MSSPAGELTCHWAITMS | Index op stats: Latch waits ms | |
36 | Data Element | MSSRANGESCANCNT | Index op stats: Count of range and table scans | |
37 | Data Element | MSSROWLCKCNT | Index op stats: Count of row locks requested | |
38 | Data Element | MSSROWLCKWAITCNT | Index op stats: Count of row lock waits | |
39 | Data Element | MSSROWLCKWAITMS | Index op stats: Row lock waits in ms | |
40 | Data Element | MSSROWOVERFLOWFTCHINBYTES | Index op stats: Data bytes from ROW_OVERFLOW_DATA | |
41 | Data Element | MSSROWOVERFLOWFTCHINPAGES | Index op stats: Data pages from ROW_OVERFLOW_DATA | |
42 | Data Element | MSSSCHEMA | Schema name | |
43 | Data Element | MSSSINGLETONLOOKUPCNT | Index op stats: Count of single row retrievals | |
44 | Data Element | MSSTABLE | Table name | |
45 | Data Element | MSSTOTLLCOUNT | Total lock or latch wait events | |
46 | Data Element | MSSTOTLLTIME | Total lock/latch wait time |