SAP ABAP Table MSSIDXOPSTATS (Index operational stats output from MSS_GET_INDEX_OP_STATS)

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	MSSIDXOPSTATS	Table Relationship Diagram
Short Description	Index operational stats output from MSS_GET_INDEX_OP_STATS

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	DBNAME	☐	MSSDB	MSSSYSNAME	CHAR	128	0	Database name
2	SCHEMANAME	☐	MSSSCHEMA	MSSSYSNAME	CHAR	128	0	Schema name
3	TABNAME	☐	MSSTABLE	MSSSYSNAME	CHAR	128	0	Table name
4	INDEXNAME	☐	MSSINDEX	MSSSYSNAME	CHAR	128	0	Index name
5	TOTAL_OPS	☐	MSSIDXOPTOTALOPS		DEC	15	0	Index op stats: Total operations on the index
6	AVPGIOLTCHWAIT	☐	MSSAVPGIOLTCHWAIT		DEC	15	3	Average page io latch wait
7	AVGPGLTCHWAIT	☐	MSSAVGPGLTCHWAIT		DEC	15	3	Average page latch wait ms
8	AVGROWLCKWAIT	☐	MSSAVGROWLCKWAIT		DEC	15	3	Average rowlock wait ms
9	AVGPGLCKWAIT	☐	MSSAVGPGLCKWAIT		DEC	15	3	Average pagelock wait ms
10	LEAF_INSERT_COUNT	☐	MSSLEAFINSCNT		DEC	15	0	Index op stats: Cumulative count of leaf-level inserts
11	LEAF_DELETE_COUNT	☐	MSSLEAFDELCNT		DEC	15	0	Index op stats: Cumulative count of leaf-level deletes
12	LEAF_UPDATE_COUNT	☐	MSSLEAFUPDCNT		DEC	15	0	Index op stats: Cumulative count of leaf-level updates
13	LEAF_GHOST_COUNT	☐	MSSLEAFGHOSTCNT		DEC	15	0	Index op stats: Count of leaf-level rows marked for delete
14	NONLEAF_INSERT_COUNT	☐	MSSNONLEAFINSCNT		DEC	15	0	Index op stats: Count of inserts above the leaf level
15	NONLEAF_DELETE_COUNT	☐	MSSNONLEAFDELCNT		DEC	15	0	Index op stats: Count of deletes above the leaf level
16	NONLEAF_UPDATE_COUNT	☐	MSSNONLEAFUPDCNT		DEC	15	0	Index op stats: Count of updates above the leaf level
17	LEAF_ALLOCATION_COUNT	☐	MSSLEAFALLOCCNT		DEC	15	0	Index op stats: Count of leaf-level page allocations
18	NONLEAF_ALLOCATION_COUNT	☐	MSSNONLEAFALLOCCNT		DEC	15	0	Index op stats: Count of non leaf-level page allocations
19	LEAF_PAGE_MERGE_COUNT	☐	MSSLEAFPAGEMERGECNT		DEC	15	0	Index op stats: Count of page merges at the leaf level
20	NONLEAF_PAGE_MERGE_COUNT	☐	MSSNONLEAFPAGEMERGECNT		DEC	15	0	Index op stats: Count of page merges above the leaf level
21	RANGE_SCAN_COUNT	☐	MSSRANGESCANCNT		DEC	15	0	Index op stats: Count of range and table scans
22	SINGLETON_LOOKUP_COUNT	☐	MSSSINGLETONLOOKUPCNT		DEC	15	0	Index op stats: Count of single row retrievals
23	FORWARDED_FETCH_COUNT	☐	MSSFORWARDEDFTCHCNT		DEC	15	0	Index op stats: Rows fetched through a forwarding record
24	LOB_FETCH_IN_PAGES	☐	MSSLOBFTCHINPAGES		DEC	15	0	Index op stats: Lob fetch pages
25	LOB_FETCH_IN_BYTES	☐	MSSLOBFTCHINBYTES		DEC	15	0	Index op stats: Count of LOB data bytes retrieved
26	LOB_ORPHAN_CREATE_COUNT	☐	MSSLOBORPHANCREATECNT		DEC	15	0	Index op stats: Count of orphan LOB created
27	LOB_ORPHAN_INSERT_COUNT	☐	MSSLOBORPHANINSCNT		DEC	15	0	Index op stats:Orphan LOB values inserted during bulkop
28	ROW_OVERFLOW_FETCH_IN_PAGES	☐	MSSROWOVERFLOWFTCHINPAGES		DEC	15	0	Index op stats: Data pages from ROW_OVERFLOW_DATA
29	ROW_OVERFLOW_FETCH_IN_BYTES	☐	MSSROWOVERFLOWFTCHINBYTES		DEC	15	0	Index op stats: Data bytes from ROW_OVERFLOW_DATA
30	COLUMN_VALUE_PUSH_OFF_ROW_COUN	☐	MSSCOLUMNVALUEPUSHOFFROWCNT		DEC	15	0	Index op stats: Count of values pushed off-row for a new row
31	COLUMN_VALUE_PULL_IN_ROW_COUNT	☐	MSSCOLUMNVALUEPULLINROWCNT		DEC	15	0	Index op stats: Count of values pulled in-row
32	ROW_LOCK_COUNT	☐	MSSROWLCKCNT		DEC	15	0	Index op stats: Count of row locks requested
33	ROW_LOCK_WAIT_COUNT	☐	MSSROWLCKWAITCNT		DEC	15	0	Index op stats: Count of row lock waits
34	ROW_LOCK_WAIT_IN_MS	☐	MSSROWLCKWAITMS		DEC	15	0	Index op stats: Row lock waits in ms
35	PAGE_LOCK_COUNT	☐	MSSPAGELCKCNT		DEC	15	0	Index op stats: Page lock count
36	PAGE_LOCK_WAIT_COUNT	☐	MSSPAGELCKWAITCNT		DEC	15	0	Index op stats: Page lock wait count
37	PAGE_LOCK_WAIT_IN_MS	☐	MSSPAGELCKWAITMS		DEC	15	0	Index op stats: Page lock wait in milliseconds
38	INDEX_LOCK_PROMOTION_ATTEMPT_C	☐	MSSINDEXLCKPROMOTIONATTEMPTCNT		DEC	15	0	Index op stats: Index lock promotion attempts
39	INDEX_LOCK_PROMOTION_COUNT	☐	MSSINDEXLCKPROMOTIONCNT		DEC	15	0	Index op stats: Index lock promotions
40	PAGE_LATCH_WAIT_COUNT	☐	MSSPAGELTCHWAITCNT		DEC	15	0	Index op stats: Latch wait count
41	PAGE_LATCH_WAIT_IN_MS	☐	MSSPAGELTCHWAITMS		DEC	15	0	Index op stats: Latch waits ms
42	PAGE_IO_LATCH_WAIT_COUNT	☐	MSSPAGEIOLTCHWAITCNT		DEC	15	0	Index op stats: I/O page latch wait count
43	PAGE_IO_LATCH_WAIT_IN_MS	☐	MSSPAGEIOLTCHWAITMS		DEC	15	0	Index op stats: I/O page latch wait in ms
44	TOTAL_LL_TIME	☐	MSSTOTLLTIME		DEC	15	0	Total lock/latch wait time
45	TOTAL_LL_COUNT	☐	MSSTOTLLCOUNT		DEC	15	0	Total lock or latch wait events
46	AVG_TOTAL_LL_WAIT	☐	MSSAVGTOTLLWAIT		DEC	15	0	Average wait for a latch or a lock

History

Last changed by/on	SAP	20130604
SAP Release Created in	710