Hi all, I am going to redesign all indexes to a very important and big table, which is heavely used. To do that, I need to know all queries which are done to this table, how often, reads and so on. In order if I create or delete index for one query not to impact another important one. I trace with Profiler, specify filter DB ID, as well as Duration <>0, reads<>0. Than I load all data into SQL table. How can I find queries to a particular table? In TSQL Event Classes or Stored Procedures Event Category there is no Object ID, in Scan Event Category there is no SQL statement. The only way I see is to query table with where clause textdata like '%name of table%'. Is there any other approach to achieve that?