Viewing Server Performance with PerfMon and the PAL Tool - SQL Server 2012 Internals and Troubleshooting - page 266

TABLE 10-1 (continued)

COUNTER DESCRIPTION

FileTable 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 fi le I/O request Average time, in milliseconds, spent handling

an incoming fi le I/O request

Avg time per fi le I/O response Average time, in milliseconds, spent handling

an outgoing fi le 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 fi le I/O requests/sec Total number of incoming FileTable fi le I/O

requests per second

FileTable fi le I/O response/sec Total number of outgoing fi le 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