Sometimes your developers are overeager and are killing multiple database processes at once on your Sqlserver instance.
Several hours later they approach you with the question of what to do.
To decide if you should wait it out or restart the service is a decision that can be based on the following query in a time interval of fifteen minutes.
SELECT spid ,kpid ,login_time ,last_batch ,status ,hostname ,nt_username ,loginame ,hostprocess ,cpu ,memusage ,physical_io FROM sys.sysprocesses WHERE cmd = 'KILLED/ROLLBACK' ORDER BY kpid
Check the result and compare the RED columns.
As you can see, there is no change in physical IO therefore the advice would be to restart the Sql Service. and let Sqlserver pick up recovering in the right order.
