SQL Server 2005 and later keeps statistics about it’s own transactions.

You can leverage this data to find the procedures that take the longest to run, or are run so frequently that tuning them up could have a big impact on your overall performance.

There are numerous examples and info in this article of how to utilize this information.