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

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

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	.INCLUDE	☐				0	0	MS SQL Server: Database File List for DB02
4	LOGFILENA	☐	MSSFILE	MSSSYSNAME	CHAR	128	0	Logical file name
5	PHYFILENA	☐	MSQPHYFLNA	CHAR520	CHAR	520	0	Physical file name (full path) of the database file.
6	FILEGRPNA	☐	MSSFG	MSSSYSNAME	CHAR	128	0	Filegroup name
7	DEVFREE	☐	MSQDEVFREE		DEC	15	0	Free space left on file system (partition) in MB.
8	DBGROWTH	☐	MSSDBGROW	CHAR10	CHAR	10	0	File growth step configured in SQL Server.
9	FLSIZEMB	☐	MSQFLTSIZE		DEC	15	0	File size in MB.
10	USEDSIZEMB	☐	MSSFLUSED	CHAR10	CHAR	10	0	Used space in database file (in extents = 64kB or in MB).
11	MAX_SIZE	☐	MSSMAXSIZE	CHAR10	CHAR	10	0	File size limit in MB configured in SQL Server.

History

Last changed by/on	SAP	20130604
SAP Release Created in