Skip to content

Instantly share code, notes, and snippets.

@PandaEox

PandaEox/rollback_monitor.sql

Created April 30, 2014 05:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save PandaEox/b349b3aa4a040e37dd4f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save PandaEox/b349b3aa4a040e37dd4f to your computer and use it in GitHub Desktop.
Download ZIP
Monitor the status of a running rollback
Raw
rollback_monitor.sql
select
er.session_id,
er.command,
er.status,
er.percent_complete
from sys.dm_exec_requests as er
where command like '%rollback%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment