November 4, 2015 at 6:32 am
Hello,
We use below OLA script to do our index maintenance and one of our previous engineer designed below script on web edition and I have a question of how online index rebuild works when we have web edition. Does the online Index rebuild really works? I am thinking it only reorganizes and does not do online index rebuild. Please, correct me. Thank you.
sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master -Q "
EXECUTE [dbo].[IndexOptimize] @databases = 'DBName1',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE',
@FragmentationHigh = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@LogToTable = 'Y'" -b
November 4, 2015 at 6:36 am
Online indexing is an Enterprise only feature, so all you will ever get on a Web box with them parameters is reorganization.
November 4, 2015 at 7:20 am
That means having a parameter like Index rebuild is of no use, correrct?
November 4, 2015 at 8:17 am
No you could still rebuild offline, just need to add
INDEX_REBUILD_OFFLINE
To the list of options
November 4, 2015 at 9:10 am
Correct.
I should have stated my question clearly saying..no use of adding index rebuild online option when we use web edition.
I see you clarified my question. Thank you 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply