Skip to main content

See the actual query used by a process



SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time,
req.user_id,
req.reads,
s.login_name
FROM sys.dm_exec_requests req
inner join sys.dm_exec_sessions s
       on req.session_id = s.session_id 
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

Comments

Post a Comment

Popular posts from this blog

NMAP

It's been about 15 years since I used NMAP, I forgot how useful the tool is. To find out what services are running on an IP address simply use something like nmap -n -v -p1-10000 x.x.x.x -n tells nmap not to do name resolution (saves about 13 seconds if the IP you're scanning isn't in DNS_ -v verbose -p1-10000 says scan ports 1 to 10,000 (otherwise nmap will only scan the first 1000 ports)
Post a Comment
Read more