they all have pros and con's -

idera sql diagnostic manager tends to be a little flaky and actually consumes a fair amount of CPU from the sql box with the aggressive queries it runs. - but easy to set up and cheap

data collection can give you a massive amount of data and expect 5% cpu usage (or so my colleague informs me) - but free