IndexOptimize

[pshekhar-gsi]

Ola,

We have more than 1TB SQL Database in Azure VM and we used the following options:

EXECUTE dbo.DatabaseIntegrityCheck
@databases = 'Mgmt',
@CheckCommands = 'CHECKDB',
@PhysicalOnly = 'Y';

EXECUTE dbo.IndexOptimize
@databases = 'Mgmt',
@FragmentationLow = NULL,
@FragmentationMedium = NULL,
@FragmentationHigh = 'INDEX_REORGANIZE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30;

Both the jobs were running for more than 6 hours before we have to cancel.

Is this normal? If not, would you recommend different parameters selection?