SAP ABAP Table MSSVTLFLS (MS SQL Server vitual file statistics display)

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	MSSVTLFLS	Table Relationship Diagram
Short Description	MS SQL Server vitual file statistics display

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	LOGFILENA	☐	MSSFILE	MSSSYSNAME	CHAR	128	0	Logical file name
2	PARTITION	☐	MSSPART	CHAR10	CHAR	10	0	MS SQL Server partition name
3	FILETYPE	☐	MSSFLTYPE	CHAR4	CHAR	4	0	MS SQL Server file type
4	.INCLUDE	☐				0	0	MS SQL Server Information from ::fn_virtualfilestats
5	DBNAME	☐	MSSDB	MSSSYSNAME	CHAR	128	0	Database name
6	FILENAME	☐	MSSFILE	MSSSYSNAME	CHAR	128	0	Logical file name
7	TIMESTAMP	☐	CHAR26	CHAR26	CHAR	26	0	Character field length 26
8	IOSTALLMS	☐	MSQVTLIO		DEC	16	3	IO stall ms per read + write operation
9	IOSTALLRDMS	☐	MSSIOSTALLRDMS		DEC	16	3	IO Stall - milliseconds / read request
10	IOSTALLWRMS	☐	MSSIOSTALLWRMS		DEC	16	3	IO Stall - milliseconds / write request
11	KBREADSEC	☐	MSSKBRSEC		DEC	16	3	kilobytes read per second
12	KBWRTSEC	☐	MSSKBWSEC		DEC	16	3	kilobytes writtten per second
13	NUMREADS	☐	MSQVTLNR		DEC	16	3	Number of reads per second
14	NUMWRITES	☐	MSQVTLNW		DEC	16	3	Number of writes returned from ::fn_virtualfilestats
15	BYTESREAD	☐	MSQVTLBR		DEC	16	3	Number of bytes returned from ::fn_virtualfilestats
16	BYTESWTN	☐	MSQVTLBW		DEC	16	3	Number of bytes written from ::fn_virtualfilestats
17	KBREADREQ	☐	MSSKBRREQ		DEC	16	3	kilobytes read per request
18	KBWRTREQ	☐	MSSKBWREQ		DEC	16	3	kilobytes writtten per request

History

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