Timeline for SQL Server Deadlock Graph - Table, Page or Row Lock?
Current License: CC BY-SA 2.5
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 6, 2011 at 14:28 | vote | accept | tuseau | ||
| Apr 6, 2011 at 14:21 | comment | added | Gaius | If process 1 is holding 2699 and wants 2588, and process 2 is holding 2588 and wants 2699, that would deadlock. Remember a deadlock implies a circular dependency. | |
| Apr 6, 2011 at 14:15 | comment | added | tuseau | Thanks, that's useful. Although in my graph I have 2 processes, which appear to be using different pages: waitresource="RID: 21:1:2588:0" waitresource="RID: 21:1:2699:1" So if they are using different pages, then they can't be conflicting over the same row, correct? Because I'm using a WITH (ROWLOCK) hint on this query. | |
| Apr 6, 2011 at 13:54 | history | answered | Gaius | CC BY-SA 2.5 |