Browse by Tags

• cache
• cpu
• dmv
• runnable
• sp_who
• tsql

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...

Filed under: tsql, sql server, cache, dmv, execution, sp_who, runnable, queue, cpu