Report - Longest running queries: Include Stored Procedure name
Please include the name of the stored procedure (where applicable) in the report of "Longest running queries".
Currently I need to use SQL Search to find the procedure that includes the query.
You can do a LEFT OUTER JOIN sys.objects using objectid to find the name (objectname) of the originating stored procedure.
Louis Somers shared this idea