Filestream and FileTable Dynamic Management Views (Transact-SQL)

Applies to: yesSQL Server (all supported versions)

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.

See Also

Filestream
Filetables
Filestream and FileTable Catalog Views (Transact-SQL)
Filestream and FileTable System Stored Procedures (Transact-SQL)