SAP ABAP Table MSSDBHIST (MS SQL Server: Database space history)

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	MSSDBHIST	Table Relationship Diagram
Short Description	MS SQL Server: Database space history

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	DATE	☐	DATUM	DATUM	DATS	8	0	Date
2	TIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
3	DBNAME	☐	MSSDB	MSSSYSNAME	CHAR	128	0	Database name
4	.INCLUDE	☐				0	0	Database size information
5	DB_SIZE	☐	MSS_DBSIZE		DEC	15	0	Database size in MB
6	DB_ALLOC	☐	MSS_DBALLOC		DEC	15	0	Allocated space in database in MB
7	LOG_SIZE	☐	MSS_LOGSIZE		DEC	15	0	Log size in MB
8	LOG_ALLOC	☐	MSS_LOGALLOC		DEC	15	0	Allocated space in log in MB
9	.INCLUDE	☐				0	0	Information on the total size of all tables
10	RESERVED	☐	MSSRESSIZE		DEC	15	0	Reserved size in KB
11	NUMTABS	☐	MSSNUMTABLES		INT4	10	0	Number of user tables
12	TABDATA	☐	MSSDATASIZE		DEC	15	0	Data size in KB
13	NUMINDS	☐	MSSNUMINDEXES		INT4	10	0	Number of indexes of user tables
14	INDDATA	☐	MSSINDEXSIZE		DEC	15	0	Index size in KB
15	UNUSED	☐	MSSUNUSEDSIZE		DEC	15	0	Unused size in KB
16	NUMPROCS	☐	MSSNUMPROCS		INT4	10	0	Number of stored procedures created in DBI

History

Last changed by/on	SAP	20110908
SAP Release Created in