Hi @Pol ,
Thank you so much for posting here in Microsoft Q&A.
The session is still running. what ever the target count we achieved.
Could you please provide more details about above? What is the output message?
Normally we could have one (XX rows affected) message once delete completed.
If you kill the session, all have to rollback, which is even more expensive with a huge session.
So normally you just have to wait, and it completes or eventually it rolls back.
Adding begin and commit transaction together with try ...catch could be better to you.
You could also try to restore from a backup if failed with deleting or killing.
Best regards
Melissa
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.