How to profile for one table in SQL Server?

Question

How can I add a filter which can trace sql statements for a particular table name?

http://stackoverflow.com/questions/296906/log-table-access-using-sql-server-profiler — Mitch Wheat, Nov 02 '10 at 09:59

score 44 · Accepted Answer · edited Jul 19 '23 at 11:36

44

You can't set filter to trace specific table directly.

What you can do is specify a filter for Text Data:

File -> Properties -> Event Selection -> Column Filters -> TextData -> Like -> [Table Name]

You may find it important to wrap your table's name with wildcard characters: "%table name%".

edited Jul 19 '23 at 11:36

Ankush Madankar

answered Nov 02 '10 at 10:03

As a complement to the answer, here's how to use multiple filters: http://stackoverflow.com/a/6366780/890890 – fabriciorissetto Jun 06 '16 at 21:49
16

You may find it important to wrap your table's name with wildcard characters: "%table name%". – MalcLear Jun 15 '17 at 20:04

score 7 · Answer 2 · edited Feb 13 '17 at 17:30

This is how I could do it....

Choose below events in the profiler:

Make sure to choose Text Data, under columns.

Then under column filters choose:

DatabaseID ---> enter specific databaseID
ObjectId ---> enter specific objectID (select from sysobjects for that specific table)
ObjectName ---> enter required tablename

2 Answers2