Export (0) Print
Expand All

sys.dm_filestream_file_io_requests (Transact-SQL)

Displays a list of I/O requests being processed by the Namespace Owner (NSO) at the given moment.

Applies to: SQL Server (SQL Server 2008 R2 through current version).

Column

Type

Description

request_context_address

varbinary(8)

Shows the internal address of the NSO memory block that contains the I/O request from the driver. Is not nullable.

current_spid

smallint

Shows the system process id (SPID) for the current SQL Server’s connection. Is not nullable.

request_type

nvarchar(60)

Shows the I/O request packet (IRP) type. The possible request types are REQ_PRE_CREATE, REQ_POST_CREATE, REQ_RESOLVE_VOLUME, REQ_GET_VOLUME_INFO, REQ_GET_LOGICAL_NAME, REQ_GET_PHYSICAL_NAME, REQ_PRE_CLEANUP, REQ_POST_CLEANUP, REQ_CLOSE, REQ_FSCTL, REQ_QUERY_INFO, REQ_SET_INFO, REQ_ENUM_DIRECTORY, REQ_QUERY_SECURITY, and REQ_SET_SECURITY. Is not nullable

request_state

nvarchar(60)

Shows the state of the I/O request in NSO. Possible values are REQ_STATE_RECEIVED, REQ_STATE_INITIALIZED, REQ_STATE_ENQUEUED, REQ_STATE_PROCESSING, REQ_STATE_FORMATTING_RESPONSE, REQ_STATE_SENDING_RESPONSE, REQ_STATE_COMPLETING, and REQ_STATE_COMPLETED. Is not nullable.

request_id

int

Shows the unique request ID assigned by the driver to this request. Is not nullable.

irp_id

int

Shows the unique IRP ID. This is useful for identifying all I/O requests related to the given IRP. Is not nullable.

handle_id

int

Indicated the namespace handle ID. This is the NSO specific identifier and is unique across an instance. Is not nullable.

client_thread_id

varbinary(8)

Shows the client application’s thread ID that originates the request.

Caution note Caution

This is meaningful only if the client application is running on the same machine as SQL Server. When the client application is running remotely, the client_thread_id shows the thread ID of some system process that works on behalf of the remote client.

Is nullable.

client_process_id

varbinary(8)

Shows the process ID of the client application if the client application runs on the same machine as SQL Server. For a remote client, this shows the system process ID that is working on behalf of the client application. Is nullable.

handle_context_address

varbinary(8)

Shows the address of the internal NSO structure associated with the client’s handle. Is nullable.

filestream_transaction_id

varbinary(128)

Shows the ID of the transaction associated with the given handle and all the requests associated with this handle. It is the value returned by the get_filestream_transaction_context function. Is nullable.

Requires VIEW SERVER STATE permission on the server.

Community Additions

ADD
Show:
© 2014 Microsoft