G-Productions | dm_io_pending_io


	Home Microsoft SQL Server DigiMailing iRN Contact	Keyword

Views

Functions

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