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.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment