SUSPENDED task state - index rebuild #764
Unanswered
richardCKF
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
Uh oh!
There was an error while loading. Please reload this page.
-
I have a script running to rebuild my indexes. I tested this on our test db server and it ran perfectly. I was doing it in small increments on our production server so if needed I could stop if performance became an issue. Also did it in small batches on my test server and all worked perfectly. I did my first batch, today, ran no issues, then ran my second batch and my job is in a "SUSPENDED" task state. Its been running a 30 minutes not, instead of the 5 min it should be. Is is safe to kill the process @olahallengren ?
EXECUTE dbo.IndexOptimize
@databases = 'man_prod, fin_prod',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@Timelimit = 300,
@LogToTable = 'Y'
Beta Was this translation helpful? Give feedback.
All reactions