Requires Spotlight Cloud Professional

How to open the I/O by File drilldown for a SQL Server connection

  1. Direct your web browser to http://www.spotlightcloud.io. Sign in an click the Monitoring tab. See also Welcome to Spotlight Cloud Monitoring.
  2. Select a SQL Server connection. Select the I/O by File drilldown.

Open the IO by File drilldown for a SQL Server connection

I/O by File

Show I/O statistics for each SQL Server database file. Select an I/O statistic to sort the files by. Select a file to show detailed I/O statistics for the selected file.

Select a SQL Server database file

I/O Statistic to sort the files by

By default the files are sorted according to Total I/O.

  • Total I/O -
  • Avg Wait Per I/O -
  • Avg I/O Rate -
  • Total I/O Wait Time -
  • Total I/O -
  • Reads/s - The current rate at which SQL Server is performing physical read operations from this file
  • Writes/s - The current rate at which SQL Server is performing physical write operations to this file
  • Read -
  • Written -
  • Avg I/O Wait -
  • Avg I/O Read Wait Time -
  • Avg I/O Write Wait Time -
  • Total Reads Wait Time - The total number of milliseconds SQL Server has spent waiting for physical read operations on the file since SQL Server started. Data for SQL Server 2005 and above
  • Total Writes Wait Time - The total number of milliseconds SQL Server has spent waiting for write operations on the file since SQL Server started. Data for SQL Server 2005 and above

Maximize this panel to show the selected I/O statistic for the file plotted over time.

Plot the selected statistic over time

Columns of the table

Logical File Name

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

DB Name

The name of the SQL Server database that contains the file.

Type

The type of the file whose I/O statistics are on display. Data for SQL Server 2005 and above.

Avg Wait Per I/O

The average wait time (in milliseconds) per I/O for the database file.

Avg I/O Rate

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

Total I/O Wait Time

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

Total I/O

The number of megabytes read from and written to this file since SQL Server started (MB Read plus MB Written).

Reads/s

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

Writes/s

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

Disk

The disk where the file resides.

I/O statistics for the selected file

The statistic and its period are shown. Select the statistic to show its value plotted over time.

  • Written (MB)
  • Writes/s (writes/s)
  • Total Writes Wait Time (sec)
  • Total Reads Wait Time (sec)
  • Total I/O Wait Time (sec)
  • Total I/O (MB)
  • Size (MB)
  • Reads/s (reads/s)
  • Read (MB)
  • Avg Write Wait Time (ms/s)
  • Avg Wait Per I/O (ms)
  • Avg Read Wait Time (ms/s)
  • Avg I/O Rate (IO/s)