system query being constantly run against instance, but dont know why

  • The following query is being run against my 2012 instance, once for each DB, on a very regular basis.

    select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid

    from [<db name>].[sys].[filetable_updates_XXXXXXXXXX] with (readpast) order by table_id

    XXXXXXXX is a number.

    I dont have filetable enabled on the server so cant see why sql might be running this. Google has not turned up much. Any ideas on this?

  • Not sure of helpfulness... was running a trace and also hit multiple queries.

    select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid

    from [DEV].[sys].[filetable_updates_2105058535] with (readpast) order by table_id

    Tried to get idea of results; couldn't run the query, nor get estimated execution plan.

    Msg 208, Level 16, State 1, Line 1

    Invalid object name 'DEV.sys.filetable_updates_2105058535'.

    I have no file tables.

    Can I +1 this question??

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply