Filestream and FileTable Dynamic Management Views (Transact-SQL)

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

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.

FileTable Dynamic Management Views and Functions

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