Browse by Tags

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: sql server, dmv, cache, sp_who, cpu, tsql, queue, execution, runnable

Troubleshoot a process (SPID) using tools & TSQL queries

Published 31 May 7 10:50 AM | SSQA.net

First thing a DBA would follow to troubleshoot a query is to look at the process (SPID) ID for that query and with the help of Enterprise Manager tool looking at the Current Activity option under management pane will give you list of processes that are...

Filed under: sql server, performance, dmv, spid, sp_who, process