| title | FILESTREAM and FileTable Dynamic Management Views (Transact-SQL) | |
|---|---|---|
| description | FILESTREAM and FileTable Dynamic Management Views (Transact-SQL) | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 10/02/2023 | |
| ms.service | sql | |
| ms.subservice | system-objects | |
| ms.topic | reference | |
| helpviewer_keywords |
|
|
| dev_langs |
|
[!INCLUDE SQL Server]
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.