Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
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.