Gary DeRousse (garyderousse@yahoo.com) writes:
> Thanks for the answer. I had briefly thought of the Profiler but not
> knowing much about it, didn't know if it's suitable for this length of
> tracking, which would probably be anything from a couple of months, to
> a permanent type of thing. But I'll look into it more.

Yeah, I agree that it is not the most optimal tool for the task, but this
the standard reply to this sort of question.

It takes some elaborate filtering to get some useful data.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp