What happens if you stop the IndexOptimize job, because it is running long and causing blocking?
2
votes
2
answers
994
views
When the dbo.IndexOptimize job is running for long time and causing blocking, if we stop the job, does it cause Rollback of everything that was reorged or rebuilt? Or it just stop where it is and doesn't proceed further?
We're using SQL Server 2017 Enterprise Edition with an Always On Availability Group.
Asked by veena ranganath
(33 rep)
Oct 16, 2023, 02:29 PM
Last activity: Oct 27, 2023, 06:05 AM
Last activity: Oct 27, 2023, 06:05 AM