Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Monitoring a Rollback and sys.dm_exec_requests

The dynamic management view (DMV) sys.dm_exec_requests returns information about each request that is executing within SQL Server.

Instead of using Activity Monitor to view the status of a Rollback , use this T-SQL code

Activity monitor is based on window panes and is cumbersome to export any information.

Using  t-sql allows extra flexibility in reporting.

 

select 
der.session_id, 
der.command, 
der.status, 
der.percent_complete
from sys.dm_exec_requests as der
where command IN ('killed/rollback',’rollback’)
Author: Jack Vamvas (http://www.sqlserver-dba.com)

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.