SQL Query to find the location of the running query?
2
votes
3
answers
1225
views
I am trying to get the information about the running queries for query performance monitoring purpose.
Is there a way to get the location of the running query in SQL-server?
For instance, if I have a stored procedure running in a server and if I'm getting all the activity monitoring data for the running query, I want to fetch the path of the stored procedure in which the query is running.
Is there a query to do this or any other way to get this path?
Example Path/hierarchy :
sever/db/stored_procedure_name/query
Asked by Arav
(21 rep)
Aug 29, 2018, 01:37 PM
Last activity: Nov 11, 2018, 09:59 PM
Last activity: Nov 11, 2018, 09:59 PM