TechNet
Export (0) Print
Expand All

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.

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.

Community Additions

ADD
Show:
© 2016 Microsoft