SAP ABAP Table MSQDBDETAS (MS SQL server database space 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	MSQDBDETAS	Table Relationship Diagram
Short Description	MS SQL server database space 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	DBNAME	☐	MSQDBNAME	CHAR255	CHAR	255	0	The name of the database in SQL Server instance.
2	DBSIZE	☐	MSQDBSIZE		DEC	16	0	Database size in MB (data files).
3	DBUSEDSIZE	☐	MSQDBRESSZ		DEC	16	0	Space (MB) reserved for database objects in database files.
4	DBFREESIZE	☐	MSQDBFRESZ	INT4	INT4	10	0	Free space in the database in MB (difference size - used).
5	DBUNUSEDSZ	☐	MSQDBUNUSZ		DEC	16	0	Reserved for database objects but not used (in KB).
6	TOTTABNUM	☐	MSQTOTTBNU	INT4	INT4	10	0	Number of user tables in the database.
7	TOTTABSIZE	☐	MSQTOTTBSZ		DEC	16	0	Data size of all tables (excluding indexes) in KB.
8	TOTINDNUM	☐	MSQTOTINNU	INT4	INT4	10	0	Number of indexes in the database.
9	TOTINDSIZE	☐	MSQTOTINSZ		DEC	16	0	Size of all indexes in the database in KB.
10	TOTSPNUM	☐	MSQTOTSPNU	INT4	INT4	10	0	Number of stored procedures in database.
11	TOTSPSIZE	☐	MSQTOTSPSZ	INT4	INT4	10	0	reserved field (Size of stored procedures in database - MB).

History

Last changed by/on	SAP	20110908
SAP Release Created in