Greetings. I know that by default this tool has a built in algorithm to show only the worst performing queries for each snapshot collected. However, I'm not sure I want to use that default collected info. What I'd really like is to collect/ upload all queries taking >= X seconds, depending on the server.

Questions:

1. Is there a way to modify the default Query Stats Collection/ Upload? If so, how? I read a link that said not to, but am still curious.
2. I know I can create a trace in Profiler and save it for a Custom Collection Set. What would be really cool is to then "link" that data to the other Collections from MDW in the Server Activity and Disk Usage tabs. I realize I could figure out the sprocs that are being called behind the scenes, and have them also query the snapshots.trace_data table where my Custom Collection Set info is retained. What I've looked for online, and been unable to find, is someone else that's already doing this. I really do't want to reinvent the wheel.

Thanks!

1.Simply answer. No. It is how MDW design like.
2.Try in your test server first.