Filestream and FileTable Dynamic Management Views (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) 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.

See Also

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