Grant Fritchey (12/6/2013)

---

kevaburg (12/6/2013)

---

For this sort of thing I would recommend a server-side profiler trace. Don't use the Profiler itself if you intend to trace over an extended period.

If you're on 2008 or better, I strongly recommend not using trace. Extended events are much less intrusive, filter better, collect better information more easily. The only problem with them is that they're just a little more difficult to consume since in 2008 & 2008R2 there is no GUI available.