sys.dm_filestream_file_io_requests (Transact-SQL)
Applies to: 
SQL Server
Displays a list of I/O requests processed by the Namespace Owner (NSO) at a given moment.
| 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. Not nullable. |
current_spid |
smallint | Shows the system process ID (SPID) for the current SQL Server's connection. 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. 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. Not nullable. |
request_id |
int | Shows the unique request ID assigned by the driver to this request. Not nullable. |
irp_id |
int | Shows the unique IRP ID. This is useful for identifying all I/O requests related to the given IRP. Not nullable. |
handle_id |
int | Indicated the namespace handle ID. This is the NSO specific identifier and is unique across an instance. Not nullable. |
client_thread_id |
varbinary(8) | Shows the client application's thread ID that originates the request. Warning: 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.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. Nullable. |
handle_context_address |
varbinary(8) | Shows the address of the internal NSO structure associated with the client's handle. 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. Nullable. |
Permissions
For SQL Server 2019 (15.x) and previous versions, requires VIEW SERVER STATE permission on the server.
For SQL Server 2022 (16.x) and later versions, requires VIEW SERVER PERFORMANCE STATE permission on the server.