title: How to fix the killed/rollback state issue
body: <p>When I was running some cmd through xp_cmdshell in sql server it tooks long time to execute.So I have killed the session.But it stucks in KILLED/ROLLBACK state for long time.Its a standalone production server.I cant restart this server.Is this a performance issue? Is there any way to clear that session?</p>