sys-dm-filestream-file-io-handles-transact-sql.md

title	sys.dm_filestream_file_io_handles (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	dm_filestream_file_io_handles sys.dm_filestream_file_io_handles dm_filestream_file_io_handles_TSQL sys.dm_filestream_file_io_handles_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.dm_filestream_file_io_handle catalog view
ms.assetid	e59632f4-3292-419f-9217-ca375749f1a5
author	stevestein
ms.author	sstein

sys.dm_filestream_file_io_handles (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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

Column	Type	Description
handle_context_address	varbinary(8)	Shows the address of the internal NSO structure associated with the client's handle. Is nullable.
creation_request_id	int	Shows a field from the REQ_PRE_CREATE I/O request used to create this handle. Is not nullable.
creation_irp_id	int	Shows a field from the REQ_PRE_CREATE I/O request used to create this handle. Is not nullable
handle_id	int	Shows the unique ID of this handle that is assigned by the driver. Is not nullable.
creation_client_thread_id	varbinary(8)	Shows a field from the REQ_PRE_CREATE I/O request used to create this handle. Is nullable.
creation_client_process_id	varbinary(8)	Shows a field from the REQ_PRE_CREATE I/O request used to create this handle. Is nullable.
filestream_transaction_id	varbinary(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_type	nvarchar(60)	Is not nullable.
logical_path	nvarchar(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_path	nvarchar(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.

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

Filestream and FileTable Dynamic Management Views (Transact-SQL)