I'm trying to troubleshoot why my index rebuild doesn't work with
WITH (SORT_IN_TEMPDB = ON, ONLINE = ON) in Microsoft SQL Server 2016 (SP1-CU3) (KB4019916) - 13.0.4435.0 (X64). I get the following error:
Cannot continue the execution because the session is in the kill state.
DBCC CHECKDB which returned no errors. I have rerun with
SORT_IN_TEMPDB = OFF and it seems to work but takes a very long time. I have 86GB free disk space in TEMPDB drive, so it can't be a disk space issues.
Does anyone have any ideas?