I have a database that has a lot of adhoc sql being run against it, so i don't want to capture all execution plans. Only want those plans that are consuming lots of CPU.
Is there an elegant way to do this? I cannot seem to filter out all the showplans for insignificant queries