OlaHallengren\IndexOptimize job - what happens when we stop it while it is running? #775
Unanswered
veenasrinivas1
asked this question in
Questions & Answers
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
When the dbo.IndexOptimize job is running for long time on one of the biggest tables takes over 8-10hrs with potential for blocking, what is the best way forward? kill it and let it rollback or let it run?
We're using SQL Server 2017 Enterprise Edition with an Always On Availability Group.
Beta Was this translation helpful? Give feedback.
All reactions