Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.dm_filestream_file_io_requests (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

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.

System_CAPS_warningWarning

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:
© 2015 Microsoft