Browse by Tags

All Tags » sp_who » dmv   (RSS)
SQL Server get current executing statements - SP_WHO or SP_WHO2 or sys.dm_exec_requests
30 July 08 09:43 AM | SQL Master | 2 Comments   
As a SQL Server user or DBAs using SP_WHO or undocumented stored procedure SP_WHO2 is a common occurrence. For this there are times when you will need to run sp_who on your SQL Server to figure out who is on and what are they doing. The output is quite Read More...
TSQL to get current executing statements - SQL Server 2005
12 February 08 01:27 PM | SQL Master | 4 Comments   
Using SP_WHO or SP_WHO2 is a common way to get list of executing processes currently on the server, within SQL Server 2005 you could take advantage of DMV that lists currently-executing statements. select r.session_id ,status ,substring(qt.text,r.statement_start_offset/2, Read More...