SELECT
total_worker_time
FROM
sys.dm_exec_procedure_stats
WHERE
object_id = OBJECT_ID(N'YourProcedureName')
ORDER BY
last_execution_time
SELECT
total_worker_time
FROM
sys.dm_exec_procedure_stats
WHERE
object_id = OBJECT_ID(N'YourProcedureName')
ORDER BY
last_execution_time