Issue : I was moving a non clustered index on a 3TB table from one file-group to another (userfilegroup to index) and it took 11 hours and never completed and i had to kill the process as it was blocking other processes.
Rollback is taking forever. It has been 10 hours since i killed the process and no clue what is happening. Locks are still held and are impacting other processes.
I see the percent_complete as 0% and kill with statusonly also shows 0% after so many hours.
Can you please suggest me if there is a way that i can check if rollback is still doing anything or just got stuck . I am afraid to restart the server as it has to go through the rollback process anyways.
Only positive thing that see is under sp_who2 diskIO moving for this SPID.
****Any help is much appreciated....****