14. Convert KPID in to hexadecimal value 15. Break the debugger to execute the debugger commands (CTRL+B) or 7th Icon in menu bar. 16. Look at the stack of the thread which is waiting for lock (Blocked) by using the Hex value of KPID ~~[Hex value of KPID]s kC 17. Above threa...
The KPID is useful in that it helps us tie up what has been passed to the operating system to run commands and is actually working. Although the SPID is constant throughout the life of the connection a KPID is allocated to each task that needs to be carried out. The KPID maps back to...
I setup SQL Server Profiler to run a trace and track deadlock data and was able to get one of the deadlock graphs but I can't quite figure out why deadlock is occuring. The two statements are both updates against different records in the same table. I checked the Isolation Level and ...
Byline: DAVID SMYTHAlfieMetro, W1I LAST reviewed Alfie early in 2001, when the Manchester collective were part of the NME's annual tour of bands which the music weekly tips will make it big. I cruelly pronounced them least likely to succeed on a bill that also included whiny Irish trio ...