Timeline for Tracking down a transaction rollback
Current License: CC BY-SA 3.0
17 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 26, 2018 at 11:04 | vote | accept | paulH | ||
| Feb 19, 2018 at 17:37 | answer | added | David Browne - Microsoft | timeline score: 1 | |
| Feb 19, 2018 at 17:17 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 27, 2017 at 19:24 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 23, 2017 at 21:59 | comment | added | eckes | No firsthand experience, but maybe you see user rollbacks issued by a connection Pool which resets connections when they are returned to the pool (and not checking the transaction level).that would explain why no real rollbacks show up in the log. | |
| Nov 23, 2017 at 13:35 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 16, 2017 at 2:23 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 15, 2017 at 7:42 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 14, 2017 at 4:29 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 6, 2017 at 17:05 | comment | added | Kin Shah | Check .. sp_SQLskillsAbortedTransactions.sql - This script cracks the transaction log and shows which transactions were rolled back after a crash --> Written by Paul S. Randal, SQLskills.com | |
| Apr 6, 2017 at 14:37 | answer | added | Dominique Boucher | timeline score: 0 | |
| Dec 2, 2016 at 12:30 | comment | added | paulH | I think Extended Events would not help for me. Judging from the link you provided I would need SQL Server 2012 onwards. I guess I could use it as extra reason for pushing that upgrade! :-) | |
| Dec 1, 2016 at 22:59 | history | tweeted | twitter.com/StackDBAs/status/804460008897449984 | ||
| Nov 30, 2016 at 19:13 | comment | added | jyao | This is a good question. My initial thought is XEvent may help, and indeed, I found this link sqlscope.wordpress.com/2012/04/09/…, it may be of some help. But a more comprehensive solution will very likely include SQL:StmtStarting, SQL:StmtCompleted, and group them by session_id and see whether there is missing pair of StmtCompleted for StmtStarting, together with the rollback event to figure out the rollback at statement level. | |
| S Nov 30, 2016 at 17:32 | history | suggested | Hadi | CC BY-SA 3.0 |
Formatting
|
| Nov 30, 2016 at 17:22 | review | Suggested edits | |||
| S Nov 30, 2016 at 17:32 | |||||
| Nov 30, 2016 at 17:17 | history | asked | paulH | CC BY-SA 3.0 |