Browse by Tags

• performance
• sp_who
• spid
• sql server

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