SAP ABAP Table MSSIDXUSAGESTATS (Index usage stats output from MSS_GET_INDEX_USE_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	MSSIDXUSAGESTATS	Table Relationship Diagram
Short Description	Index usage stats output from MSS_GET_INDEX_USE_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	USER_SEEKS	☐	MSSUSEEKS		DEC	15	0	Index usage - Number of seeks by user queries.
6	USER_SCANS	☐	MSSUSCANS		DEC	15	0	Index usage - Number of scans by user queries.
7	USER_LOOKUPS	☐	MSSULOOKUPS		DEC	15	0	Index usage: Number of lookups by user queries
8	USER_UPDATES	☐	MSSUUPDATES		DEC	15	0	Index usage: Number of updates by user queries
9	USER_TOTALOPS	☐	MSSUTOTALOPS		DEC	15	0	Index usage: Total user operations on the index
10	LST_USER_SEEK	☐	MSSLSTUSEEK		CHAR	24	0	Index usage: Last user seek (sql datetime)
11	LST_USER_SCAN	☐	MSSLSTUSCAN		CHAR	24	0	Index usage: Last user scan (sql datetime)
12	LST_USER_LOOKUP	☐	MSSLSTULOOKUP		CHAR	24	0	Index usage: Last user lookup (sql datetime)
13	LST_USER_UPDATE	☐	MSSLSTUUPDATE		CHAR	24	0	Index usage: Last user update (sql datetime)
14	SYSTEM_SEEKS	☐	MSSSYSSEEKS		DEC	15	0	Index usage: Number of seeks by system queries
15	SYSTEM_SCANS	☐	MSSSYSSCANS		DEC	15	0	Index usage: Number of scans by system queries
16	SYSTEM_LOOKUPS	☐	MSSSYSLOOKUPS		DEC	15	0	Index usage: Number of lookups by system queries
17	SYSTEM_UPDATES	☐	MSSSYSUPDATES		DEC	15	0	Index usage: Number of updates by system queries
18	LAST_SYS_SEEK	☐	MSSLSTSYSSEEK		CHAR	24	0	Index usage: Time of last system seek
19	LAST_SYS_SCAN	☐	MSSLSTSYSSCAN		CHAR	24	0	Index usage: Time of last system scan
20	LAST_SYS_LOOKUP	☐	MSSLSTSYSLOOKUP		CHAR	24	0	Index usage: Time of last system lookup
21	LAST_SYS_UPDATE	☐	MSSLSTSYSUPDATE		CHAR	24	0	Index usage: Time of last system update

History

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