Yes that was my point really, I wasn't able to get a decent workload as I collected too much information.

I wondered if collecting workloads should be performed at the database level to keep the amount collected down, it sound like you both do? What about at table level also do people collect workloads at that level?

I see a lot of mentioning of ensure you collect workloads, but never have I seen a detailed explanation of what that means.