sys.dm_filestream_file_io_requests
Displays a list of I/O requests being processed by the Namespace Owner (NSO) at the 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. 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. Is not nullable |
request_state |
nvarchar(60) |
Shows the state of the I/O request in NSO. 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. ![]()
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. |
Permissions
Requires VIEW SERVER STATE permission on the server.