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
-
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