SQL Server collecting SQL statements using particular index
the following query will find all the queries that are using that particular index at realtime

  select  i.object_id,
     i.index_id, i.name,
     tqp.query_plan,pl.plan_handle, pl.start_time,pl.estimated_completion_time,q.text
  from sys.indexes as i
    cross apply (select quotename(i.name) as name) as i2
    cross apply sys.dm_exec_requests as pl
    cross apply sys.dm_exec_query_plan(pl.plan_handle) AS p
    CROSS APPLY sys.dm_exec_text_query_plan(pl.plan_handle, DEFAULT, DEFAULT) tqp
    cross apply sys.dm_exec_sql_text(pl.plan_handle) q
    where i.name = 'YourIndex'