SQL Server – kill with statusonly Posted by Ray Fox 0 When a SQL Server process is killed (kill spid), the non-commited work (transactions) will take a certain amount of time to roll back. Use kill spid with statusonly to determine how much time a killed process will take to rollback