Menu
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?
702
It's can be found under the Tools menu. To start a trace in it, click Create new trace and then select columns you want to monitor, followed by clicking Run . Show activity on this post. Built in performance monitor can track traffic if you set it up to do so and want to trace when not logged in.
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), or 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.
70
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
