You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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?
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.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
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