Microsoft – SQLServer – Transaction Rollback – Status

Microsoft – SQLServer – Transaction Rollback – Status


Needed help monitoring the status of a transaction rollback.

If the process is already killed, then you might try using “kill <x> with status only”.

replace <x> with the SPID/session_id.

    Syntax:

       kill  with status_only;

     Sample:

       --if the session we will like to kill is session_id 53
       kill 53 with status_only;

Here are a couple of online gems.


References
:
1) Kill (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms173730.aspx

2) Monitor Transaction Rollback
http://www.daveturpin.com/2011/07/monitor-transaction-log-rollback/

3) How long will this rollback take?
http://www.jimmcleod.net/blog/index.php/2012/06/

4) Killed /Rollback
http://connect.microsoft.com/SQLServer/feedback/details/433703/killed-rollback 

5) SQLMail hung in Schedule Job – Restart it without restarting SQL Server
http://keentiger.com/2007/05/24/sqlmail-hung-in-schedule-job-restart-it-without-restart-sql-server-services/

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s