Sample Header Ad - 728x90

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