sm_iransoftware (2/2/2015)
HiOur DB was slow from yesterday.
(some times is good and some times long waits)
I Run sp_who2 And many Blocked spid found.
Such as : n spid blocked by 54
When I see 54 : in cmd column : "Awaiting Command"
1- What is meaning of this cmd? And What Do I Do about them ?
2- What do I do , for seeing current Blocked Transaction And a history of them ?
3- What about DBCC OpenTran ? What can we do with this command? It returns some cods and ids, no command ... and sql text and ... ?
thank you
A lot of blocks (and even maybe deadlocks?) would prompt me to send the code back to the developers to have it written properly. What sort of changes have been made since it ran well and now?