select *  from sys.procedures as p

inner join sys.dm_exec_procedure_stats as q

on p.object_id = q.object_id