SAP ABAP Table MSSOPUSESTATS (Combined index operational and use statistics)

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	MSSOPUSESTATS	Table Relationship Diagram
Short Description	Combined index operational and use statistics

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

History

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