| |
This
is a 2005 sort of sp_who3,
which'll return connection info as well as the running command.
Also included is the SQL
Server 2000 equivalent and also a means of seeing zero cost plans.
/********* live requests (running ones) *************/
SELECT
st.text
as
[Command text],
login_time,
[host_name],
program_name,
sys.dm_exec_requests.session_id,
client_net_address,
sys.dm_exec_requests.status,
command,
db_name(database_id)
as
DatabaseName
FROM
sys.dm_exec_requests
inner
join
sys.dm_exec_connections
on
sys.dm_exec_requests.session_id
=
sys.dm_exec_connections.session_id
inner
join
sys.dm_exec_sessions
on
sys.dm_exec_sessions.session_id
=
sys.dm_exec_requests.session_id
cross
apply
sys.dm_exec_sql_text(sql_handle)
AS st
WHERE
sys.dm_exec_requests.session_id
>= 51
GO
/********* use against a spid to check TSQL - limited to 255
chars *************/
/********* use sp_who3 to run this on all processes
*************/
dbcc inputbuffer(myspid)
/********* returns upto 800 characters *************/
/********* use DBCC TRACEON (2861) to cache and see zero cost
plans also *************/
DECLARE @handle
binary(20)
SELECT @handle
= sql_handle
FROM
master..sysprocesses
WHERE
spid =
myspid
SELECT
*
FROM
::fn_get_sql(@handle)
|
|
