Search code examples
sqlsql-serversql-server-2012sql-server-profiler

filetable_updates table in SQL Server Profiler

Recently we started monitoring the SQL Profiler to capture queries executed in server.

Strangely we observed the below query executed for every single minute in Database. 

SELECT table_id,
       item_guid,
       oplsn_fseqno,
       oplsn_bOffset,
       oplsn_slotid
FROM   [Databasename].[sys].[filetable_updates_2105058535] WITH (readpast)
ORDER  BY table_id

enter image description here

When I tried to execute manually, it throwing error saying

Msg 208, Level 16, State 1, Line 1 Invalid object name 'Databasename.sys.filetable_updates_2105058535'.

It is using sys schema not dbo

Can somebody give insight of this process. Is this something to worry about I searched through forum didn't get any answer. Sometimes it is executing more than twice for a minute

Solution

  • if your database has filestream/filetable, you will see these queries being run by the system occasionally:

                select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid
            from [database].[sys].[filetable_updates_<some_id>] with (readpast) order by table_id

    So, may you may want to add additional filtering to the above query to filter those out (as long as the filter doesn't accidentally filter out queries you do care about). This is probably a safe addition to that derived table:

                AND t.[text] NOT LIKE N'%oplsn_fseqno%'

    And one more is The AlwaysOn feature must be enabled for the server instance ‘xxxxx\SQL2K12’ before you can create an availability group on this instance. To enable AlwaysOn, open the SQL Server Configuration Manager, select SQL Server Services, right-click the SQL Server instance name, select Properties, and use the AlwaysOn High Availability tab of the SQL Server Properties dialog.

    More Info :

    1.System process queries

    2.2012 AlwaysON Setup

    please let us know if you have any concerns.