To run this query, start SQL Server Management Studio, Open New Query window and copy below query in it. Now click on Execute button to run this query.

Run the above query using SQL server management studio. The result will be different than below screenshot.

Output Details: TEXT: The query is being executed. session_id: Session id assigned to query. We can use this id to kill this query status: Current status of the query Start_time: The time query was started.

SQL Server   Find Currently Running Query   TecAdmin - 71