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).
Shows the internal address of the NSO memory block that contains the I/O request from the driver. Is not nullable.
Shows the system process id (SPID) for the current SQL Server’s connection. Is not nullable.
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
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.
Shows the unique request ID assigned by the driver to this request. Is not nullable.
Shows the unique IRP ID. This is useful for identifying all I/O requests related to the given IRP. Is not nullable.
Indicated the namespace handle ID. This is the NSO specific identifier and is unique across an instance. Is not nullable.
Shows the client application’s thread ID that originates the request.
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.
Shows the address of the internal NSO structure associated with the client’s handle. Is nullable.
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.