MySQL and SQL Server

SQL Server and MySQL DBA.

Wednesday, 8 April 2015

Check SQL Server killed session rollback percentage

KILL spid WITH STATUSONLY


Result as below:
SPID 91: transaction rollback in progress. Estimated rollback completion: 50%. Estimated time remaining: 1559 seconds.



Posted by Unknown at 02:55 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2018 (1)
    • ►  October (1)
  • ►  2017 (4)
    • ►  July (1)
    • ►  April (3)
  • ►  2016 (7)
    • ►  December (1)
    • ►  November (1)
    • ►  October (1)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
  • ▼  2015 (10)
    • ►  December (1)
    • ►  November (1)
    • ►  September (2)
    • ►  August (3)
    • ►  July (1)
    • ▼  April (1)
      • Check SQL Server killed session rollback percentage
    • ►  January (1)
  • ►  2014 (11)
    • ►  September (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (2)
    • ►  April (2)
    • ►  March (2)
    • ►  January (1)
  • ►  2013 (23)
    • ►  December (1)
    • ►  November (2)
    • ►  October (3)
    • ►  September (3)
    • ►  August (5)
    • ►  July (9)

About Me

Unknown
View my complete profile
Simple theme. Powered by Blogger.