SAP ABAP Table MSQVTLFLS (MS SQL Server Information from ::fn_virtualfilestats)

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	MSQVTLFLS	Table Relationship Diagram
Short Description	MS SQL Server Information from ::fn_virtualfilestats

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

History

Last changed by/on	SAP	20110908
SAP Release Created in	50A