sql server - How to monitor just t-sql commands in SQL Profiler?

Question

I have a trouble in monitoring t-sql commands, I want to monitor just commands like: select, insert, update or delete. Can anyone help me?

Answer 1

Pick a trace template (such as Tuning) and use a filter.

Either filter by a particular login (such as your own login or a service's login), a particular database.

For instance, to filter by database: Under Trace properties -> Events tab -> Select show all columns. Set a Like filter on database name.

I find setting a filter on the number of Logical Reads of say > 10 reads, filters out most of the noise.

• How to: Filter Events in a Trace
• Using SQL Server Profiler