Rebuild index frequency/schedule and delay?

Duchemin, Dominique 2,011 Reputation points
2022-08-24T18:12:45.653+00:00

Hello,

  1. How often do you run the rebuild index on the SQL MEMCM Database CM_UCP?
  2. How long does it run?
  3. do you use?

EXECUTE dbo.IndexOptimize
@Databases = 'USER_DATABASES',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@UpdateStatistics = 'ALL',
@OnlyModifiedStatistics = 'Y'

  1. or another script/job?

Thanks,
Dom

Microsoft Security | Intune | Configuration Manager | Other
SQL Server | Other
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Garth 5,801 Reputation points
    2022-08-25T00:59:43.977+00:00
    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.