Rebuild index frequency/schedule and delay?

Duchemin, Dominique 2,006 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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,597 questions
Microsoft Configuration Manager
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