SQL Trace (or SQL Profiler) is no doubt an excellent tool. But its filtering capability is rather primitive, and is very poorly documented. Here is a request that is simple and seems to be rather reasonable.
Create a trace to filter for the following:
1. All the update/delete statements, and
2. All the select/insert statements whose CPU column value is greater than 1000 or whose Duration value is greater than 1000
Now, I'm having a tough time creating a trace to meet this simple requirement. Perhaps, I'm missing something obvious, and I'd be very happy if you prove that's the case.