index-maintenance

Version 1.1 by Rudi Marais on 2022/02/04 15:28

 

Install these scripts from the maintenance package at https://ola.hallengren.com/

  1. CommandExecute.sql
  2. CommandLog.sql
  3. IndexOptimize.sql

Documentation for the index maintenance methods can be found here: SQL Server Index and Statistics Maintenance (hallengren.com)

EXECUTE dbo.IndexOptimize
@Databases = 'Everest_PreProd',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@UpdateStatistics = 'ALL',
@FillFactor = 80,
@Execute  = 'Y',
@LogToTable = 'Y'
Tags:
Created by Rudi Marais on 2022/02/04 15:28