The single most helpful tool I don't see regularly used is a table count and date on all the tables, followed by a periodic grab of the data.

Obviously a trace is going to tell you a lot of about what is going on, but the volume of the data is much more extensive.