great article. for a very very basic sql user like me, this is great!
Now, I want to use the info from the trace in SCOM, and I know SCOM can read logs. but would it be possible to somehow add a logic that would generate a NT log event when queries take longer than x ms?
Then the scom side would just have to catch that event in the nt log.
Thank you in advamce