While debugging a long running stored procedure I wanted to include SP:stmtStarting and SP:stmtCompleted.
I noticed that every 25 seconds I was getting multiple queries against every database on my local server like:
select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid
from [dbname].[sys].[filetable_updates_random_number] with (readpast) order by table_id
From different sid's each time.
While searching I saw that sometimes this may had to do with always on availability or filestream support but this is not my case since I don't use any of these features. This is a single instance installation.
The following queries return no rows.
SELECT * FROM sys.filetables; GO SELECT * FROM sys.tables WHERE is_filetable = 1; GO
@@version returns:
Microsoft SQL Server 2012 (SP1) - 11.0.3401.0 (X64) Jan  9 2014 13:22:15 Copyright (c) Microsoft Corporation Develo ...

Go to the complete details ...