SQL Server Tacklebox- P26

SQL Server Tacklebox- P26: This book, as with almost all books, started out as an idea. I wanted to accumulate together those scripts and tools that I have built over the years so that DBAs could sort through them and perhaps adapt them for their own circumstances. | 5 DBA as detective different and in my opinion too difficult to maneuver when trying to home in on a problem as quickly as possible. That is primarily the reason I am compelled to run both 2005 and 2008 versions of the client tools. Sp_who2 on the other hand always works and the results are generally instantaneous. It displays among many other things any blocking on the SQL Server instance on which the problem has been reported. Running sp_who2 on the affected server reveals that there are indeed blocked processes as is evidenced by the BlkBy field in the results see Figure . .Rep sa 56 sp_who2 - .5 Executing. 5QLQuery5. ql -. .4 Executing. . Automated_DBC. .ster sa 57 - . Ex 1 . Q. 1Z1 Results Messages SPID Stalus Login H. BlkBy DBName Command CPUTime DiskIO LastB atch ProgramName SPID REQUESTID 6 6 BACKGROUND sa . master SIGNAL HANDLER 0 0 05 0318 11 04 6 0 7 7 BACKGROUND sa NULL LOCK MONITOR 0 0 05 0318 11 04 7 0 8 8 sleeping sa master TASK MANAGER 0 0 05 0318 11 04 8 0 9 9 BACKGROUND sa . master FSAGENT TASK 0 0 05 0318 11 04 3 0 10 10 BACKGROUND sa . master FSAGENT TASK 0 0 05 0318 11 04 10 0 11 11 BACKGROUND sa master FSAGENT TASK 0 0 05 0318 11 04 11 0 12 12 BACKGROUND sa master FSAGENT TASK 0 1 05 0318 11 04 12 0 13 13 BACKGROUND sa . master FSAGENT TASK 0 3 05 0318 11 04 13 0 14 14 BACKGROUND sa master TRACE QUEUE TASK 0 0 05 0318 11 04 14 0 15 15 BACKGROUND sa master BRKR TASK 0 0 05 0318 11 04 15 0 16 16 BACKGROUND sa NULL CHECKPOINT 0 0 05 0318 11 04 16 0 17 17 BACKGROUND sa . master TASK MANAGER 0 0 05 0318 11 04 17 0 10 18 BACKGROUND sa master BRKR EVENT HNDLR 0 37 05 0318 11 04 18 0 19 19 BACKGROUND sa master BRKR TASK 0 0 05 0318 11 04 19 0 20 20 BACKGROUND sa . master BRKR TASK 0 0 05 0318 11 04 20 0 21 21 sleeping sa master TASK MANAGER 0 0 05 0318 11 04 21 0 22 22 sleeping sa master TASK MANAGER 0 0 05 0318 11 04 22 0 23 23 sleeping sa I . master TASK MANAGER 0 2 05 0318 11 04 23 0 24 24 sleeping sa .