GilaMonster (3/3/2013)
It does work, it's the correct and only way to get the rollback status and progress.Check what the rolling back session is waiting for.
My experience is that it does not always work.
I have seen many threads in which this is a problem and does not work as it should.
How do you check what the rollback session is waiting for?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/