Monday, 19 September 2016

How to Get the Running query text using DMV ?

Following is the one of the way to find the running query in SQL server.

In the query window 1 i ran the below query and  my server process ID is 55 and it is highlighted below.
For demonstration purpose i used the following query.




In the query window 2 i ran the below query to find the running query as shown below.


No comments:

Post a Comment