Index Optimize doesn't seem to be working #737
Unanswered
stanz71
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 an index optimization job setup but it doesn't seem to be working on some of my tables where there are thousands of pages and fragmentation is around 10%+. Below are the parameters being used. Am I looking at this wrong?
EXECUTE [dbo].[IndexOptimize]
@databases = 'SYSTEM_DATABASES,%prod%,%arch%',
@FragmentationLow = 'INDEX_REORGANIZE',
@FragmentationMedium = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE,INDEX_REORGANIZE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE,INDEX_REORGANIZE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@UpdateStatistics = NULL,
@MinNumberOfPages = 500,
@Timelimit = 2400,
@LockTimeout = 120,
@OnlyModifiedStatistics = 'Y',
@LogToTable = 'Y'-b
Below is an example of one that it doesn't seem to be working on. The fragmentation doesn't seem to decrease, and I don't see the index listed in the log file the job creates at all.
Beta Was this translation helpful? Give feedback.
All reactions