SQL Server, FileTable object
Applies to: 
SQL Server
The SQLServer:FileTable performance object provides counters for statistics associated with FileTable and non-transacted access.
This following table describes the SQL Server FileTable performance objects.
| SQL Server FileTable counters | Description |
|---|---|
| Avg time delete FileTable item | Average time (in milliseconds) taken to delete a FileTable item. |
| Avg time FileTable enumeration | Average time (in milliseconds) taken for a FileTable enumeration request. |
| Avg time FileTable handle kill | Average time (in milliseconds) taken to kill a FileTable handle. |
| Avg time move FileTable item | Average time (in milliseconds) taken to move a FileTable item. |
| Avg time per file I/O request | Average time (in milliseconds) spent handling an incoming file I/O request. |
| Avg time per file I/O response | Average time (in milliseconds) spent handling an outgoing file I/O response. |
| Avg time rename FileTable item | Average time (in milliseconds) taken to rename a FileTable item. |
| Avg time to get FileTable item | Average time (in milliseconds) taken to retrieve a FileTable item. |
| Avg time update FileTable item | Average time (in milliseconds) taken to update a FileTable item. |
| FileTable db operations/sec | Total number of database operational events processed by the FileTable store component per second. |
| FileTable enumeration reqs/sec | Total number of FileTable enumeration requests per second. |
| FileTable file I/O requests/sec | Total number of incoming FileTable file I/O requests per second. |
| FileTable file I/O response/sec | Total number of outgoing file I/O responses per second. |
| FileTable item delete reqs/sec | Total number of FileTable delete item requests per second. |
| FileTable item get requests/sec | Total number of FileTable retrieve item requests per second. |
| FileTable item move reqs/sec | Total number of FileTable move item requests per second. |
| FileTable item rename reqs/sec | Total number of FileTable rename item requests per second. |
| FileTable item update reqs/sec | Total number of FileTable update item requests per second. |
| FileTable kill handle ops/sec | Total number of FileTable handle kill operations per second. |
| FileTable table operations/sec | Total number of table operational events processed by the FileTable store component per second. |
| Time delete FileTable item BASE | For internal use only. |
| Time FileTable enumeration BASE | For internal use only. |
| Time FileTable handle kill BASE | For internal use only. |
| Time move FileTable item BASE | For internal use only. |
| Time per file I/O request BASE | For internal use only. |
| Time per file I/O response BASE | For internal use only. |
| Time rename FileTable item BASE | For internal use only. |
| Time to get FileTable item BASE | For internal use only. |
| Time update FileTable item BASE | For internal use only. |
Example
You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:
SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%FileTable%';