Rollin,
In SSMS, Object Explorer, rightclick the database, Reports, Object Execution Statistics.
>Is there a way to collect query response times regularly (as a part of maintenance and monitoring) other than using Profiler? I would like to collect the database name, query name, and time to completion.