SAP ABAP Table MSSSHOWCONOUT (Output of dbcc showcontig)

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	MSSSHOWCONOUT	Table Relationship Diagram
Short Description	Output of dbcc showcontig

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	TABLENAME	☐	MSSTABLE	MSSSYSNAME	CHAR	128	0	Table name
2	OBJECTID	☐	MSSOBJID		INT4	10	0	Object id
3	INDEXNAME	☐	MSSINDEX	MSSSYSNAME	CHAR	128	0	Index name
4	INDEXID	☐	MSSINDEXID		INT2	5	0	Index id
5	LEVEL	☐	MSSINDLEVEL		INT4	10	0	Index level
6	PAGES	☐	MSSILPAGES		DEC	16	0	Number of pages in index level
7	ROWS	☐	MSSILROWS		DEC	16	0	Number of data or index rows in index level
8	ROWMINLEN	☐	MSSILROWMINLEN		INT4	10	0	Minimum row size in index level
9	ROWMAXLEN	☐	MSSILROWMAXLEN		INT4	10	0	Maximum row size in index level
10	ROWAVGLEN	☐	MSSILROWAVGLEN		DEC	12	2	Average row size in index level
11	FORWARDEDROWS	☐	MSSILFWDROWS		DEC	16	0	Number of forwarded rows in index level
12	EXTENTS	☐	MSSILEXTENTS		DEC	16	0	Number of extents in index level
13	EXTENTSWITCHES	☐	MSSEXTSWITCHES		DEC	16	0	Number of extent switches
14	AVGFREEBYTES	☐	MSSAVGFREEBYTES		DEC	6	2	Average number of bytes free per page
15	AVGPAGEDENSITY	☐	MSSAVGPGDENSITY		DEC	5	2	Average page density
16	SCANDENSITY	☐	MSSSCANDENSITY		DEC	5	2	Scan density
17	BESTCOUNT	☐	MSSBESTCOUNT		DEC	16	0	Ideal number of extent changes
18	ACTUALCOUNT	☐	MSSACTCOUNT		DEC	16	0	Actual number of extent changes
19	LOGICALFRAG	☐	MSSLOGSCANFRAG		DEC	5	2	Logical scan fragmentation
20	EXTENTFRAG	☐	MSSEXTSCANFRAG		DEC	5	2	Extent scan fragmentation

History

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