The I/O by File grid shows current SQL Server I/O statistics for each Azure SQL Managed instance database file.

For each SQL Server file you can see:

DBName

The name of the Azure SQL Managed instance database that contains the file.

File Name

The name of the file whose I/O statistics are on display.

File Type

The type of the file whose I/O statistics are on display.

Total I/O Rate

The current rate (per second) at which SQL Server is performing both physical read and write operations for this file (Reads Rate plus Writes Rate).

Reads Rate

The current rate at which SQL Server is performing physical read operations from this file.

Writes Rate

The current rate at which SQL Server is performing physical write operations to this file.

Wait per I/O

The wait time per I/O (in milliseconds per I/O) for the database file. A value greater than 10 to 15 milliseconds per I/O indicates bad performance.

Total I/O

The number of kilobytes read from and written to this file since Azure SQL Managed instance started (KB Read plus KB Written).

KB Read

The number of kilobytes read from this file since Azure SQL Managed instance started.

KB Written

The number of kilobytes written to this file since Azure SQL Managed instance started.

KB on Disk

Physical file size on disk in kilobytes.

Total Wait Time

The total number of milliseconds SQL Server has spent waiting for I/O operations on this file since Azure SQL Managed instance started.

Reads Wait Time

The total number of milliseconds SQL Server has spent waiting for physical read operations on the file since Azure SQL Managed instance started.

Writes Wait Time

The total number of milliseconds SQL Server has spent waiting for write operations on the file since Azure SQL Managed instance started.

Current Wait Time

The number of milliseconds SQL Server has spent waiting for I/O operations on this file since the last time data was collected for this page.

Current Reads Wait Time

The number of milliseconds SQL Server has spent waiting for physical read operations on this file since the last time data was collected for this page.

Current Writes Wait Time

The number of milliseconds SQL Server has spent waiting for write operations on this file since the last time data was collected for this page.

Disk

The disk where the file resides.

How to restrict the file(s) that are included in the chart below

You can restrict the files(s) that are included in the chart below by clicking on the file(s) you are interested in.