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

• winston Smith

  SSCoach

  Points: 19500

  More actions

  June 11, 2013 at 11:59 am

  #278414

  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?

• alocyte 93598

  SSC Veteran

  Points: 228

  More actions

  November 25, 2013 at 4:46 am

  #1668752

  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??