Executing procedure on management studio usually takes 10 minutes, it took over an hour today. I had no luck to see if there were any locks that is causing the slowness because the sql queries to check locks did not work on our client production db.. May be it's some permissions issue that I'm not able to run sql queries on the master database to check the locks.. So I had no go but to kill the session on my management studio. Rollback has been running for about 2.5hrs now.. I checked the rollback status I get 'SPID 121: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds. So it's clearly not doing any roll back here. Is there a way to kill the process at the OS level? Since it's production we do not want to bounce the service...
Please help.. thanks much