Reduce rollback duration on SQL Server Transaction
Rollback and duration to rollback on a large transaction is a problem in SQL systems to maintain. There are cases the rollback duration is longer than the commit itself. Terminating long transactions (example index rebuild) in Always On environment is a nightmare. If customers failover the AG by mistake then the pending rollback creates additional problems. Compete products such as Oracle RDBMS have overcome this issue by adding a undo/redo/rollback segments. A similar solution needs to be added in SQL server too. Customers have openly expressed their unhappiness on this and compare SQL Server with Oracle frequently.
A solution or feature needs to be added to overcome long rollback duration. It will make a good compete with Oracle RDBMS. Contact me to discuss further and to find a potential solution on this. Thanks.