I tried an
alter table X add column C
, but it was taking too long and rolled back(actually killed it). When I did so, sp_who2 showed DiskIO = 5 mil.
Is it meaningful to assume that it will take another 5 mil to complete the rollback, regardless of time? If not, is there some kind of multiplier that has to do with the transaction logs?
Asked by George Menoutis
(447 rep)
Sep 26, 2023, 06:23 AM
Last activity: Sep 26, 2023, 01:14 PM
Last activity: Sep 26, 2023, 01:14 PM