Feature request: Report - Longest running queries: Include Stored Procedure name
LouisSomers
Posts: 23 Bronze 2
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 object_id to find the name (object_name) of the originating stored procedure.
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 object_id to find the name (object_name) of the originating stored procedure.
Comments
Can you please post your suggestion on our uservoice forum at https://sqlmonitor.uservoice.com/forums/91743-suggestions?
That forum is monitored by the Product Management team who use it as an important source when deciding what features to add or enhance in the tool
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools
It can be voted for at https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/38143162