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.
30
votes
![](https://secure.gravatar.com/avatar/43710d5ec01601f9cd36fddd2eb8f39c?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)