sys.dm_filestream_non_transacted_handles (Transact-SQL)


Updated: June 10, 2016

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

Displays the currently open non-transactional file handles associated with FileTable data.

This view contains one row per open file handle. Because the data in this view corresponds to the live internal state of the server, the data is constantly changing as handles are opened and closed. This view does not contain historical information.

For more information, see Manage FileTables.

database_idintID of the database associated with the handle.
object_idintObject ID of the FileTable the handle is associated with.
handle_idintUnique handle context identifier. Used by the sp_kill_filestream_non_transacted_handles (Transact-SQL) stored procedure to kill a specific handle.
file_object_typeintType of the handle. This indicates the level of the hierarchy the handle was opened against, ie. database or item.
correlation_process_idvarbinary(8)Contains a unique identifier for the process that originated the request.
correlation_thread_idvarbinary(8)Contains a unique identifier for the thread that originated the request.
file_contextvarbinary(8)Pointer to the file object used by this handle.
stateintCurrent state of the handle. May be active, closed or killed.
current_workitem_typeintState this handle is currently being processed by.
fcb_idbigintFileTable File Control Block ID.
item_idvarbinary(892)The Item ID for a file or directory. May be null for server root handles.
is_directorybitIs this a directory.
item_namenvarchar(512)Name of the item.
opened_file_namenvarchar(512)Originally requested path to be opened.
database_directory_namenvarchar(512)Portion of the opened_file_name that represents the database directory name.
table_directory_namenvarchar(512)Portion of the opened_file_name that represents the table directory name.
remaining_file_namenvarchar(512)Portion of the opened_file_name that represents the remaining directory name.
open_timedatetimeTime the handle was opened.
flagsintShareFlagsUpdatedToFcb = 0x1,
DeleteOnClose = 0x2,
NewFile = 0x4,
PostCreateDoneForNewFile = 0x8,
StreamFileOverwritten = 0x10,
RequestCancelled = 0x20,
NewFileCreationRolledBack = 0x40
login_idintID of the principal that opened the handle.
login_namenvarchar(512)Name of the principal that opened the handle.
login_sidvarbinary(85)SID of the principal that opened the handle.
read_accessbitOpened for read access.
write_accessbitOpened for write access.
delete_accessbitOpened for delete access.
share_readbitOpened with share_read allowed.
share_writebitOpened with share_write allowed.
share_deletebitOpened with share_delete allowed.

Manage FileTables

Community Additions