Hi
We are on Pricing Tier -> Premium P4: 500 DTUs
Manually ran Ola Hallengrens script modified as below
@FragmentationMedium nvarchar(max) = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE', @FragmentationHigh nvarchar(max) = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE', @FragmentationLevel1 int = 50, @FragmentationLevel2 int = 80,
@UpdateStatistics = 'ALL', @OnlyModifiedStatistics = 'Y', @StatisticsSample int = NULL
This should be less intensive than a fullscan option scanning all rows in a table or doing an index rebuild at lower fragmentation levels
Despite this the Compute Utilization quickly reaches 100% - even thought this was running out of hours i stopped the process after 7 minutes
Is this expected behaviour at this Pricing Tier?
We would like to schedule this to run weekly.
Thanks