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?
Kill the windows process linked to xp_cmdshell and if it does not rollback I guess the only solution will be to restart the instance.