Home Microsoft SQL Server DigiMailing iRN Contact
    Keyword



sys.dm_io_pending_io_requests

 

This is a view in the mssqlsystemresource database.  

Returns a row for each pending I/O request in SQL Server. VIEW SERVER STATE permission is needed for the requesting user.

This query tells you the amount of outstanding I/O:

select vfs.database_id, df.name, df.physical_name,vfs.file_id, ior.io_pending, ior.io_handle, vfs.file_handle
from sys.dm_io_pending_io_requests ior
inner join sys.dm_io_virtual_file_stats (DB_ID(), NULL) vfs on (vfs.file_handle = ior.io_handle)
inner join sys.database_files df on (df.file_id = vfs.file_id)
where df.name = ‘Log file name'

 

Column name Data type Description

io_completion_request_address

varbinary(8)

Memory address of the IO request. Is not nullable.

io_type

varchar(7)

Type of pending I/O request. Is not nullable.

io_pending

int

Indicates whether the I/O request is pending or has been completed by Windows. An I/O request can still be pending even when Windows has completed the request, but SQL Server has not yet performed a context switch in which it would process the I/O request and remove it from this list. Is not nullable.

io_completion_routine_address

varbinary(8)

Internal function to call when the I/O request is completed. Is nullable.

io_user_data_address

varbinary(8)

Internal use only. Is nullable.

scheduler_address

varbinary(8)

Scheduler on which this I/O request was issued. The I/O request will appear on the pending I/O list of the scheduler. For more information, see sys.dm_os_schedulers. Is not nullable.

io_handle

varbinary(8)

File handle of the file that is used in the I/O request. Is nullable.

io_offset

bigint

Offset of the I/O request. Is not nullable.

io_pending_ms_ticks

int

Internal use only. Is not nullable.

 




Syntax
CREATE VIEW sys.dm_io_pending_io_requests AS
	SELECT *
	FROM OpenRowSet(TABLE SYSIOS)

 
Last revision 2008RTM
News

  Query a named instance
Sybase+ASE+silent+install
SQL 2008 R2
Deprecated procedures in SQL2008
Reporting Services item-level role definitions
Create all your missing indexes
Converting datetime field
Start MSSQL Server Profiler at time
Replicating MSSQL Server views
Exploring Microsoft Sharepoint
The OLE DB provider "SQLNCLI10" for linked server indicates.
Mobile solar charger
Oracle to SQL Server replication
Cannot insert the value NULL into column
Undocumented Microsoft SQL Server 2008
VMware
Zoekmachine optimalisatie
SQL Servers hidden objects
FckEditor
Flash in Ajax
De hype die AJAX heet
Barcode scannen
MySQL; Gratis, makkelijk en snel!
PHP
sIFR; de combinatie tussen HTML en Flash