SAP ABAP Table MSSDBSZINF (MS SQL Server: Database Size Information)

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	MSSDBSZINF	Table Relationship Diagram
Short Description	MS SQL Server: Database Size Information

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	☐	MSSDDBNAME	TEXT30	CHAR	30	0	MS SQL Server: Database name
2	DBTOTSIZE	☐	MSSDBTOTSZ	INT4	INT4	10	0	MS SQL Server database total size
3	DBRESSIZE	☐	MSSDBRESSZ	INT4	INT4	10	0	MS SQL Server database reserved size (in 2K pages)
4	DBFRESIZE	☐	MSSDBFRESZ	INT4	INT4	10	0	MS SQL Server database free size (in 2K pages)
5	DBUNUSIZE	☐	MSSDBUNUSZ	INT4	INT4	10	0	MS SQL Server database unused size (2K pages)
6	TABLENUM	☐	MSSTABNUM	INT4	INT4	10	0	MS SQL Server number of tables within the database
7	TABLESIZE	☐	MSSTABSIZE	INT4	INT4	10	0	MS SQL Server total size of all tables within DB (in 2k pgs)
8	INDEXNUM	☐	MSSINDNUM	INT4	INT4	10	0	MS SQL Server total number of indexes within this database
9	INDEXSIZE	☐	MSSTOTINSZ	INT4	INT4	10	0	MS SQL Server total index size within the database (#2K pgs)
10	SPNUM	☐	MSSSPNUM	INT4	INT4	10	0	MS SQL Server total number of stored procedured within DB
11	SPSIZE	☐	MSSSPSIZE	INT4	INT4	10	0	MS SQL Server total size of stored procedures (2K pages)

History

Last changed by/on	SAP	20110908
SAP Release Created in