Timeline for Transaction rollback hanging from past two months(MSSQL 2016)
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 3, 2019 at 6:09 | vote | accept | swchen | ||
| Apr 3, 2019 at 6:09 | answer | added | swchen | timeline score: 1 | |
| S Mar 19, 2019 at 10:50 | history | edited | András Váczi | CC BY-SA 4.0 |
Corrected spelling, fixed grammar mistakes and reformatted.
|
| S Mar 19, 2019 at 10:50 | history | suggested | Learning_DBAdmin | CC BY-SA 4.0 |
Corrected spelling, fixed grammar mistakes and reformatted.
|
| Mar 19, 2019 at 9:59 | review | Suggested edits | |||
| S Mar 19, 2019 at 10:50 | |||||
| Mar 19, 2019 at 8:41 | comment | added | Sabin B |
What waits do you have for that session ? sys.dm_exec_session_wait_stats ; also a good helper is sp_WhoIsActive
|
|
| Mar 19, 2019 at 8:10 | comment | added | swchen |
@SabinBio I ran the query and don't get any wait type shows ASYNC_IO_COMPLETION. Thanks.
|
|
| Mar 19, 2019 at 7:40 | review | First posts | |||
| Mar 19, 2019 at 7:59 | |||||
| Mar 19, 2019 at 7:37 | history | asked | swchen | CC BY-SA 4.0 |