Browse by Tags

All Tags » dmv » cache » tsql » sp_who (RSS)
TSQL to get current executing statements - SQL Server 2005
Published 12 February 8 2:27 PM | SSQA.net
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...
Filed under: , , , , , , , ,