The Database File virtual table gives you an overview of the operating system files that store the database. The Database File virtual table contains the following fields.

Field Description

No.

The number of the operating system file.

File Name

The operating system file name.

Size (KB)

The size of the operating system file in kilobytes.

Total Reads

The number of read accesses since the database was opened.1

Mean Read Time (ms)

The average time for a read operation (in milliseconds).1

Reads In Queue

The number of read operations waiting in queue.1, 2

Total Writes

The number of write operations since the database was opened.1

Mean Write Time (ms)

The average time for a write operation (in milliseconds).1

Writes In Queue

The number of write operations waiting in queue (in milliseconds).1, 2

Disk Load (%)

A percentage weight describing the load on the disk.1

1 Not available in the SQL Server Option for Microsoft Dynamics NAV.

2 Only if Commitcache = Yes.

NoteImportant

If a solution uses any of the fields that are not available in the SQL Server Option for Microsoft Dynamics NAV, it will have to be modified to run on SQL Server. These fields will not be created on SQL Server. If the program tries to access them, an error message appears.

Expand imageViewing Database File Information

Expand imageSee Also