Command 'Kill with statusonly ' do not show any progress.
Hi All - We're having a SQL Server EE 2012 SP1 + CU5 version (11.00.3373) and Windows 2008 R2 SP1 EE (x64). Its a physical machine.
we tried to kill a 'Alter Index command with offline' SPID status show as KILLED/ROLLBACK. We tried to get estimated time for rollback by using command 'Kill with statusonly ' but it don't show any progress.
We couldn't recycle SQL Server services because it will take whole database into recovery mode and other tables also won't be accessible.
Is already a bug created for this issue ?
This needs to be addressed
please fix this issue. It is really embarrassing and frustrating not to know when a rollback will complete.
This would be very helpful in determining next steps during a potentially site down situation.
This is one of those embarrassing situations when you have to tell the customer that SQL doesn't know when a rollback will complete, can be 5 min or 5 hours, makes no sense.
Vinod Jacob commented
Its almost 2 years - surely with the number comments below
You would have addressed this by now
Please fix this.
Please fix this!!! So many times Executives have asked when the rollback will complete, and I tell them "I don't know". It truly causes them to question their investment in Microsoft!
Please fix this, Microsoft.
Please fix this Microsoft
MS has to fix that issue