sys.dm_filestream_file_io_handles (Transact-SQL)
Collapse the table of content
Expand the table of content

sys.dm_filestream_file_io_handles (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Displays the file handles that the Namespace Owner (NSO) knows about. Filestream handles that a client got using OpenSqlFilestream are displayed by this view.

ColumnTypeDescription
handle_context_addressvarbinary(8)Shows the address of the internal NSO structure associated with the client’s handle. Is nullable.
creation_request_idintShows a field from the REQ_PRE_CREATE I/O request used to create this handle. Is not nullable.
creation_irp_idintShows a field from the REQ_PRE_CREATE I/O request used to create this handle. Is not nullable
handle_idintShows the unique ID of this handle that is assigned by the driver. Is not nullable.
creation_client_thread_idvarbinary(8)Shows a field from the REQ_PRE_CREATE I/O request used to create this handle. Is nullable.
creation_client_process_idvarbinary(8)Shows a field from the REQ_PRE_CREATE I/O request used to create this handle. Is nullable.
filestream_transaction_idvarbinary(128)Shows the ID of the transaction associated with the given handle. This is the value returned by the get_filestream_transaction_context function. Use this field to join to the sys.dm_filestream_file_io_requests view. Is nullable.
access_typenvarchar(60)Is not nullable.
logical_pathnvarchar(256)Shows the logical pathname of the file that this handle opened. This is the same pathname that is returned by the .PathName method of varbinary(max) filestream. Is nullable.
physical_pathnvarchar(256)Shows the actual NTFS pathname of the file. This is the same pathname returned by the .PhysicalPathName method of the varbinary(max) filestream. It is enabled by trace flag 5556. Is nullable.

Requires VIEW SERVER STATE permission on the server.

Filestream and FileTable Dynamic Management Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft