SAP ABAP Table MSQSHCONTG (Displays fragmentation info for data and indexes of a table)

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	MSQSHCONTG	Table Relationship Diagram
Short Description	Displays fragmentation info for data and indexes of a table

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	OBJNAME	☐	MSQOBTNAME		CHAR	128	0	Table or index name.
2	OBJID	☐	MSQOBJID	INT4	INT4	10	0	SQL Server object or index ID.
3	INDEXNAME	☐	MSQOBTNAME		CHAR	128	0	Table or index name.
4	INDEXID	☐	MSQOBJID	INT4	INT4	10	0	SQL Server object or index ID.
5	INDEXLEVEL	☐	MSQIDXLEVL		INT4	10	0	Level within the index tree - 0 is the leaf (or data) level.
6	CNTPAGES	☐	MSQIDXPAGS		INT4	10	0	No. of pages in the index level.
7	CNTROWS	☐	MSQIDXROWS		INT4	10	0	No. of rows in that level of the index.
8	MINRECSIZE	☐	MSSMINRCSZ		INT4	10	0	Minimum record size in that level of the index.
9	MAXRECSIZE	☐	MSSMAXRCSZ		INT4	10	0	Maximum record size in that level of the index.
10	AVGRECSIZE	☐	MSQAVRWSZ		DEC	16	2	Average record size (byte).
11	FORWARDREC	☐	MSQIXFORRD		INT4	10	0	No. of forwarded records in that index level or entire heap.
12	EXTENTS	☐	MSQIDXEXTS		INT4	10	0	No. of extents in that index level or entire heap.
13	EXTSWITCH	☐	MSQEXTSWIT		INT4	10	0	No. of extent switches by traversing the index level.
14	AVGFRBYTES	☐	MSQAVFRBYT		DEC	16	2	Average number of free bytes on the pages scanned.
15	AVGPGDENS	☐	MSQAVPGDEN		DEC	16	2	Average page density as percentage (the higher, the better).
16	SCANDNSITY	☐	MSQSCANDEN		DEC	16	2	Scan density of extents (100% is the best value).
17	BESTEXTCNT	☐	MSQBESTEXT		INT4	10	0	Ideal no. of extent changes if all are contiguously linked.
18	ACTEXTCNT	☐	MSQACTEXCT		INT4	10	0	Number of extents scanned ( = extent switches +1).
19	LOGIFRAG	☐	MSQLOGFRAG		DEC	16	2	Logical fragmentation in leaf-pages of an index.
20	EXTFRAG	☐	MSQEXTFRAG		DEC	16	2	Extent fragmentation in scanning the leaf pages of an index

History

Last changed by/on	SAP	20110908
SAP Release Created in	50A