Tracking query performance over period of time

by May 8, 2014

I’m researching whether or not SQL DM has the ability to either report on query performance over recent periods by default or if I can configure it to do so going forward. The request has come across to benchmark certain tasks (i.e. queries) at the database level in order to compare to other periods with varying traffic and volume, so I’d need to be able to identify specific queries to track, and not just “slow” or poorly performing queries.