CODEWITHSUNDEEP
sqlsql-serversql-server-2008
buttowski
buttowski

Reputation: 4917

Query to get list active queries in my SQL Server

I want to get a list of information of active queries that are running in my SQL Server (in order to kill a few of those queries).

I want a query to get this required information:

| query_id (if possible) | query_text | query_start_time | time_elapsed | host_name | user_group | query_status |

I am new to SQL Server please suggest....

Upvotes: 3

Views: 22618

Answers (1)

roman
roman

Reputation: 117540

Try this

select 
    r.session_id,
    r.status,
    r.command,
    r.cpu_time,
    r.total_elapsed_time,
    t.text
from sys.dm_exec_requests as r
    cross apply sys.dm_exec_sql_text(r.sql_handle) as t

Upvotes: 8

Related Questions