Displaying 1 result from an estimated 1 matches for "pp778".
Did you mean:
ppp78
2005 Dec 19
0
Dtrace & thread deadlock detection
...seconds. This thread inspects a list of waiting locks for any cycles, which would indicate a circular relationship between processes holding locks & processes waiting for locks. The db then chooses a victim & kills one of the processes. (See "Inside MS SQL Server" by Delaney, pp778 for details on how the MS DB does this)
Dtrace can''t do that, but it would be nice to know when deadlocks occur and include a stack trace of the involved threads.
What I have in mind is:
1. Use a profile provider that fires every 5 seconds or so & looks at a given process.
2. It...