Browse by Tags

• dmv
• kill
• kpid
• performance
• process
• processes
• rollback
• sp_who
• sp_who2
• sql server
• sysprocesses
• transaction log
• transactions

SQL Server - Kill a KILLED/ROLLBACK status process without restarting Server or SQL services?
06 May 08 01:02 AM | SQL Master | 2 Comments   

This may be the typical situation within your database environment where the you might have killed a SPID (Process) that has been running for long time, without knowing the ROLLBACK operations for such processes. Say if you are executing a stored procedure Read More...

Filed under: sql server, spid, transactions, transaction log, processes, kill, rollback, sysprocesses, kpid, sp_who2

Troubleshoot a process (SPID) using tools & TSQL queries
31 May 07 08:50 AM | SQL Master | 2 Comments   

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

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