title

Filestream and FileTable Dynamic Management Views (Transact-SQL) | Microsoft Docs

ms.custom

ms.date

03/03/2017

ms.prod

sql

ms.reviewer

ms.technology

system-objects

ms.topic

language-reference

dev_langs

TSQL

helpviewer_keywords

FileTables [SQL Server], dynamic management views

ms.assetid

e50a135d-6644-42a4-a0df-1c7a2b722051

author

stevestein

ms.author

sstein

Filestream and FileTable Dynamic Management Views (Transact-SQL)

This section describes the dynamic management views related to the FILESTREAM and FileTable features.

Filestream Dynamic Management Views and Functions

sys.dm_filestream_file_io_handles (Transact-SQL)
Displays the currently open transactional file handles.

sys.dm_filestream_file_io_requests (Transact-SQL)
Displays current file input and file output requests.

sys.dm_filestream_non_transacted_handles (Transact-SQL)
Displays the currently open non-transactional file handles to FileTable data.