SALES: 1-800-867-1380
Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

sys.dm_filestream_non_transacted_handles (Transact-SQL)

SQL Server 2012

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.

Column

Type

Description

database_id

int

ID of the database associated with the handle.

object_id

int

Object ID of the FileTable the handle is associated with.

handle_id

int

Unique handle context identifier. Used by the sp_kill_filestream_non_transacted_handles (Transact-SQL) stored procedure to kill a specific handle.

file_object_type

int

Type of the handle. This indicates the level of the hierarchy the handle was opened against, ie. database or item.

file_object_type_desc

nvarchar(120)

“UNDEFINED", “SERVER_ROOT", “DATABASE_ROOT", “TABLE_ROOT", “TABLE_ITEM"

correlation_process_id

varbinary(8)

Contains a unique identifier for the process that originated the request.

correlation_thread_id

varbinary(8)

Contains a unique identifier for the thread that originated the request.

file_context

varbinary(8)

Pointer to the file object used by this handle.

state

int

Current state of the handle. May be active, closed or killed.

state_desc

nvarchar(120)

“ACTIVE", “CLOSED", “KILLED"

current_workitem_type

int

State this handle is currently being processed by.

current_workitem_type_desc

nvarchar(120)

“NoSetWorkItemType", “FFtPreCreateWorkitem", “FFtGetPhysicalFileNameWorkitem", “FFtPostCreateWorkitem", “FFtPreCleanupWorkitem", “FFtPostCleanupWorkitem", “FFtPreCloseWorkitem", “FFtQueryDirectoryWorkItem", “FFtQueryInfoWorkItem", “FFtQueryVolumeInfoWorkItem", “FFtSetInfoWorkitem", “FFtWriteCompletionWorkitem"

fcb_id

bigint

FileTable File Control Block ID.

item_id

varbinary(892)

The Item ID for a file or directory. May be null for server root handles.

is_directory

bit

Is this a directory.

item_name

nvarchar(512)

Name of the item.

opened_file_name

nvarchar(512)

Originally requested path to be opened.

database_directory_name

nvarchar(512)

Portion of the opened_file_name that represents the database directory name.

table_directory_name

nvarchar(512)

Portion of the opened_file_name that represents the table directory name.

remaining_file_name

nvarchar(512)

Portion of the opened_file_name that represents the remaining directory name.

open_time

datetime

Time the handle was opened.

flags

int

ShareFlagsUpdatedToFcb = 0x1, DeleteOnClose = 0x2, NewFile = 0x4, PostCreateDoneForNewFile = 0x8, StreamFileOverwritten = 0x10, RequestCancelled = 0x20, NewFileCreationRolledBack = 0x40

login_id

int

ID of the principal that opened the handle.

login_name

nvarchar(512)

Name of the principal that opened the handle.

login_sid

varbinary(85)

SID of the principal that opened the handle.

read_access

bit

Opened for read access.

write_access

bit

Opened for write access.

delete_access

bit

Opened for delete access.

share_read

bit

Opened with share_read allowed.

share_write

bit

Opened with share_write allowed.

share_delete

bit

Opened with share_delete allowed.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft