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.
Important |
---|
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. |