Wednesday, September 7, 2011

Find Currently Running Query In The SQL Server

This script is very handy to check the currently running Query in the server. 

USE MASTER
GO
SELECT B.TEXT,
A.session_id,
A.status, 
A.command, 
A.cpu_time, 
A.total_elapsed_time 
FROM sys.dm_exec_requests A 
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS B
GO
Find Currently Running Query, T-SQL , What SQL Statements Are Currently Executing, Viewing current PostgreSQL queries, How to check oracle database for long running queries, Finding currently running queries, Identifying currently running SQL queries, Actions on currently running queries, How to monitor currently running queries, currently running queries sql server 2005, in sql server 2012, in sql server 2008 R2, in sql server 2008,

1 comments:

Post a Comment